- ©«¤l
- 56
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 81
- ÂI¦W
- 0
- §@·~¨t²Î
- Window7
- ³nÅ骩¥»
- OFFICE2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-6-25
- ³Ì«áµn¿ý
- 2016-1-17
|
¤u§@ªí·|¨Ì¾Ú«ü©w½d¥»ÀÉ¡A³v¨B·s¼WExcel½d¥»Local¥Î1¡BExcel½d¥»Local¥Î2¡B¡B¡ASheet §Ú«h¥uª¾¹D¨Ï¥Î Copy «á¦Û°Ê¥[(2)¡B(3)
³o¬O³Ì²³æªº¡An¤£±o¥ÎÅܼơA¦ý¤Ó³Â·Ð
¦p³æ¯Â¼Æ¦r»¼¼W¥i¥Î
Sub NewWKB()
Set wkb = Workbooks.Add(Template:="C:\Excel½d¥»Local¥Î.xls") ' ¤Þ¥Î½d¥»¡A«ü©w½d¥»ÀÉ®×
MsgBox wkb.Name
Sheets(1).Copy Before:=Sheets(1)
End Sub
Sub NSHT()
Sheets(1).Copy Before:=Sheets(1) '·s¼W¤u§@ªí¡A¥ý©R¦W sheet(1)
End Sub |
|