[分享]工资条打印，已将附件更新了一下..希望对你有用

flyes

代码很简单，但是功能很强大，佩服。

TGB

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>winghorse</i>在2006-12-13 20:54:00的发言：</b><br/><p>学会VB真好,想用什么都可以轻易搞定!!!不知在哪里可以入门?</p></div><p>就在这个论坛上，有兴趣到程序版去看看吧！</p><p>谢谢各位回贴的兄弟！</p>

Ali1109

<p>这是正是我想要的资料,谢谢!!!</p>

1978dyx

可否告诉一下，工资条的题头如何更改，XX厂2008年2月工资条能否改成自己想要的题头多谢

163wx

<table cellspacing="0" cellpadding="0" width="715" border="0" style="WIDTH: 536pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="5" width="64" style="WIDTH: 48pt;"></col><col width="75" style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742;"></col><col span="5" width="64" style="WIDTH: 48pt;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td width="64" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"></td><td width="331" colspan="5" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 248pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">优点是不用动手去挨个拷贝工作表,只消用鼠标点击</font></td><td width="64" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td width="64" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td width="64" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td width="64" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td width="64" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; WIDTH: 48pt; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">注意</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">1</font></td><td colspan="4" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">每个工作表的1 至3行请保持格式相同</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">2</font></td><td colspan="4" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">每个工作表的人员记录应从第4行开始</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">3</font></td><td colspan="10" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">本例的数据是工作表中的A:Z列,如果你的数据超过Z列请修改代码注释中有*号的地方,(老鸟请不要怪我罗嗦)</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">4</font></td><td colspan="3" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">列宽请根据实际情况修改代码</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">5</font></td><td class="xl24" colspan="7" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: #ffcc00; mso-ignore: colspan;"><font size="2">数据多时可能速度会受到影响,这里如果各位有好的方法望不吝赐教,先谢了!</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td align="right" height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2">6</font></td><td colspan="3" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent; mso-ignore: colspan;"><font size="2">水平有限,请各位多提意见.</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2"></font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2">TGB</font></td><td class="xl25" align="right" style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"><font size="2">2006-9-17</font></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"></td><td style="BORDER-RIGHT: #fffff1; BORDER-TOP: #fffff1; BORDER-LEFT: #fffff1; BORDER-BOTTOM: #fffff1; BACKGROUND-COLOR: transparent;"></td></tr></tbody></table>不错，好东西

caodwei

谢谢。太好了。

zhhgg

谢谢楼主,辛苦啦~~~

lee_forever

收下了、谢谢

lafel2008

谢谢分享，支持原创！

hs5321

谢谢楼主正是需要的找了很长时间。