- ©«¤l
- 92
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 195
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-8-15
- ³Ì«áµn¿ý
- 2011-8-11
|
¤µ¤Ñ¨ì¤½¥q¡A°µ¤F¥H¤Uªº´ú¸Õ...
§Ú¥ý¥H¥[¤JOption Explicitªºµ{¦¡½X°õ¦æ¡A°£¤FºC¥H¥~¨ÃµL²§±`²{¶H¡C
¦A¨Ó´N¬O¡AÃö³¬Application.ScreenUpdating = FalseÆ[¹î¥¦ªº°õ¦æª¬ªp¡A
¥¦¥H10´X¬íªº³t«×¦b°µ¤Á´«.....¤H¨ÆºÞ²z.xls©M¥X¶ÔÁZ®Ä.xls
(®a¸Ìªº¹q¸£¬O¥H¥b¬íªº³t«×°µ¤Á´«)
«á¨Ó¡A§Ú°µ³v¦æ°»¿ù....«öµÛF8¤£©ñ~
«Ü©úÅ㪺µ{§Ç¥d¦b..¶}±ÒÀɮשMÃö³¬Àɮ׳o¨â¦æ(¦U¬ù10´X¬í)
Workbooks.Open Filename:="D:\¤H¨ÆºÞ²z\¥X¶ÔÁZ®Ä.xls
Windows("¥X¶ÔÁZ®Ä.xls").Close
½Ð°Ý¦U¦ì¤j¤j¡A¦b¤°»òª¬ªp¤U¡A·|¾ÉP¶}±Ò¡BÃö³¬Àɮ׳t«×ÅܺC?? |
|