- ©«¤l
- 19
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 29
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2011-10-31
- ³Ì«áµn¿ý
- 2014-11-13
|
[µo°Ý] VBA ¦p¦ó¨Ì§Ç¶}±Ò EXCELÀɮשO
¥»©«³Ì«á¥Ñ ag324 ©ó 2011-10-31 11:36 ½s¿è
Àɮ׬OCSV ÀÉ ¤£¹L¥ÎWorkbooks.Open Filename dir/ xxx.xls
§Ú§â¥¦·í§@xls Àɮפ]¯à¶}
§Ú¦³¤@Ó°ÝÃD
´N¬O§Ú¦³«Ü¦hÀÉ®× n²Î¾ã¸ê®Æ¨ì¤@ÓÀÉ®×
ÀɦW¬°1.csv 2csv .....¨ì xxx,csv
¦bÓ§O¶] VBA §â¸Ì±ÀÉ®×·J¾ã¨ì§Ú¥t¥~¶}ªº¤@ÓÀɮ׸Ì
§Ú¤º®e³£¼g¦n¤F
´N¬O¤£ª¾¹D «ç»òÅý¥L¶] ¶}±Ò 1.csv ¶]VBA µM«á¦A¶] 2.csv ¶]VBA
·PÁÂ
-----------------------------------------------------------------------
¦pªGn¶]¦hÓ¸ê®Æ§¨ ¸Ì±ªº¦UÀÉ®× ¤Sn«ç»ò³]©O
¦U¸ê®Æ§¨¸Ì±¤]¬O 1.csv 2.csv ...µ¥ |
|