ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤Z¨Æ°_ÀYÃø

¤Z¨Æ°_ÀYÃø

¦pªG¦³¤H¦í¦b¥x¥_¡A¥i¥H§ä§Ú°Q½×
Excel VBA µ{¦¡³]­p¤Jªùªº°ÝÃD¡A
§Ú­Ì ¤@°_¶i¨B¡C

§Úªº¥Ø¼Ð¬O ¥x«ü´Á³f µ{¦¡¥æ©ö¡C
§Ú¦³·Qªk©Mµ¦²¤¡A§Ú·|¼gµ{¦¡
¥Ø«e¡A´N¥u®t¦b DDE ªº³ø»ù¸ê®Æ¡A
¦p¦ó ¶i¤J Excel , ©M ¦Û°Ê¤U³æ ³o¨â­Ó³¡¤À

·íµM¡A§Aªº¥Ø¼Ð ¤£¤@©w­n¸ò§Ú¬Û¦P¡A
¥u­n¬O §A·Q¾Ç²ß Excel VBA µ{¦¡³]­p¡A³£¥i¥H §K¶O§ä§Ú
¤Ñ¤U¬°¤½

¦^´_ 1# sjgau


    «Ü·Q§ä±z¤@°_¬ã¨s

¤£¹L§Ú¤H¦b¥x¤¤Q____Q

TOP

¦^´_ 2# handsometrowa

ºô¸ô µL°ê¬É¡A³z¹Lºô¸ô µL»·¥±©¡

ÁÙ¬O¥i¥H ¤@°_¬ã¨s
¤Ñ¤U¬°¤½

TOP

§A¥Ø«e­n§@ªº¤w¸g¬OVBA µ{¦¡À³¥Îµ¥¯Å¡AExcel VBA µ{¦¡³]­p¤Jªùªº°ÝÃD·|¤£·|¼vÅT§A¶i«×¡C
§Ú¬O·Q¾ÇVBA¤]¦b¥x¥_©Ò¥H¥ý·hªO¹¹¦û­Ó¦ì¤l¡A¥ýÁÂÁ¼ӥDªº¼ö¤ß¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ¤£·|°Ú

¥i¥H ±Ð¾Ç¬Ûªø
¤Ñ¤U¬°¤½

TOP

¦^´_ 5# sjgau
ªº½T¡A¤Z¨Æ°_ÀYÃø¡A±Ð¾Ç¬Û±`¤¬«j¤¬Ày¡I

TOP

¦^´_ 1# sjgau


·Q¾Ç²ß Excel VBA  ¦ý¤H¦í¤¤³¡¡A°£¤F¤W¥x¥_¡A
¤£ª¾¦³¤°»ò¤è¦¡¥i¥H¾Ç²ß¡C·PÁÂ!

TOP

¦^´_ 7# chiu827067


    ¥Ø«e ³o­Ó ®É¶¡ÂI¡A¤£¬O©M ¤W¥x¥_¨Ó¬Ý§Ú¡C

¦]¬°¡A§Ú¤]¬O ·¡·ì ªì¾Çªº¦y¬q¡C
«Øij¡A¸g±`¨ì ³o­Ó°Q½×°Ï¬Ý¬Ý¡A§Y¥i
¤Ñ¤U¬°¤½

TOP

¦^´_ 8# sjgau


¦¬¨ì~~·PÁÂS¤j´£¿ô¡C:)

TOP

¦^´_ 9# chiu827067


    ³o¼Ë¦n¤F¡A§Ú¦³ ¥ô¦óªº¤ß±o¡A¥ß¨è¦b³o¸Ìµoªí ¤À¨É¡C

§A¬Ý¤F¡A¦³¥ô¦óªº¤£¤F¸Ñ¡A¥ß¨è ´£¥X°Q½×

¥ý¨Ó¤@­Ó VBA ªº "hello, world! "
¬¡­¶Ã¯1.rar (10.95 KB)
¤Ñ¤U¬°¤½

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD