¼gVBA¨Ì§Ç¶}±ÒÃþ¦üªºexcelÀÉ
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan/Taipei
- µù¥U®É¶¡
- 2011-8-22
- ³Ì«áµn¿ý
- 2012-4-24
|
¼gVBA¨Ì§Ç¶}±ÒÃþ¦üªºexcelÀÉ
§Ú·Q¼g¤@ÓVBA¨Ì§Ç¶}±ÒÀɦW¬°ABC1.xls, ABC2.xls, ABC3.xls....ªºexcelÀÉ
§Ú¸Õ¹L¥Îopen¥~¥[°j°é¦ý¤£¦æ,¦³errorµo¥Í
·Q½ÐªO¤W¦U¦ì¤j¤jÀ°¦£,·P¿E¤£ºÉ
¥t¥~,§Ú·Q¦b¦³VBAªºexcelÀɬY¤TÓÀx¦s®æ¼g113,115,18³o¤TӼƦr,µM«á³o¤TӼƦr·|¹ïÀ³¨ì¥´¶}ªºexcelÀÉ,¦pABC1.xls
µM«á¶i¦æ·j´M,·í§ä¨ì³o¤TӼƦr«á,¦b¥¦Ì©Ò¦bªºcolumn¶i¦æ¿z¿ï³Ì¤jÈ,¤]·Q½Ð°Ýª©¤W¤j¤j¦³¤°»ò¦n·N¨£¶Ü?
ÁÂÁÂ!!! |
|
wsiad
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan/Taipei
- µù¥U®É¶¡
- 2011-8-22
- ³Ì«áµn¿ý
- 2012-4-24
|
¦^´_ 7# Hsieh
¬O§Ú·Q¿ù¤F,§Ú¥H¬°with end with ÁÙ¦³¨ä¥L¥Îªk,¦]¬°¤£¼ôªºÃö«Y
¤µ¤Ñ¦A¬ã¨sµo²{¥¦´N¥u¬O¬Ù²¤ª«¥ó¦WºÙ¤è«K,´N¹³.Close¤@¼Ë
sorry
¥t¥~,§ÚÁÙ·Q½ÐHsieh¤j§A¦AÀ°§Ú¼g¨âÓ§PÂ_¦¡¦n¶Ü?¦b§Úmodule1¸Ì±§Ú¦³µù¸Ñ
¦A³Â·Ð§A¤F,§Úªº¥¨¶°´N³Ñ³o¨âÓ¦a¤è¦b°µ¤@¤U¨¾§b´N¸Ñ¨M¤F
·PÁÂ!!!
Wisad.rar (54.98 KB)
|
|
wsiad
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan/Taipei
- µù¥U®É¶¡
- 2011-8-22
- ³Ì«áµn¿ý
- 2012-4-24
|
¦^´_ 5# Hsieh
Hsieh¤j ÁÂÁÂ!
·Q½Ð°Ý¬°¤°»ò13¦æªº".Close"Y§ï¦¨"Close",ÁöµMÁÙ¬O¥i¥H¨úȦýì©lÀÉ«o¨S¿ìªkÃö±¼©O?
Close¤£´N¬OÃö±¼©Ò¦³¶}±Òªº¬¡¶Ã¯,¦b³o¸Ì¬O§âì©lÀÉÃö±¼?!
¥t¥~,¥i¥H¦A½Ð±ÐWith....End withªº¥Îªk¶Ü?
§Ú¤@ª½¤£¬O«Ü²M·¡¥¦ªº¥\¥Î©Î¥Îªk,¥uª¾¹D¦bWith...End with°Ï¶ô¤ºªºÄݩʤ£¥Î¦A¥´¤@¦¸ª«¥ó¦WºÙ
¦ý¬Ý½d¨Ò©Î¬O¨ä¥L¤Hªº¦n¹³ÁÙ¦³¨ä¥L¥Î³~
¤Q¤À·PÁÂ!!! |
|
wsiad
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan/Taipei
- µù¥U®É¶¡
- 2011-8-22
- ³Ì«áµn¿ý
- 2012-4-24
|
Hsieh¤j
¨ä¹ê¥unGetData.xlsªºCell(3,13)Àx¦s®æ¤º®e¯à°÷³Q1.xlsªºRows("7:7")Äæ·j´M¨ì,§Úªº°ÝÃD´N¸Ñ¨M¤@¥b¤F,§Ú´N¤ñ¸û¦³§â´¤³Ñ¤Uªº¥i¥H¦Û¤v¨Ó,·PÁ§AªºÀ°¦£³á!!! |
|
wsiad
|
|
|
|
|
- ©«¤l
- 5
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 11
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan/Taipei
- µù¥U®É¶¡
- 2011-8-22
- ³Ì«áµn¿ý
- 2012-4-24
|
¦^´_ 2# Hsieh
º¥ýÁÂÁÂHsieh¤jªºÀ°¦£, ¦^µª¤@¥i¥H¥Î
Wisad.rar (284.22 KB)
¦Ü©ó°ÝÃD¤G,³Â·Ð½Ð¬ÝÀ£ÁYÀɤºGetData.xls module-housing¸Ìªºµù¸Ñ´yz,ÁÂÁ |
|
wsiad
|
|
|
|
|