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

[µo°Ý] µLªk±NVBA¦Û°Ê°õ¦æ¼g¶iµ{¦¡¸Ì

[µo°Ý] µLªk±NVBA¦Û°Ê°õ¦æ¼g¶iµ{¦¡¸Ì

¤p§Ì±qªB¤Í¨ºÃ䮳¨ì¤@­Ó¬ö¿ýDDE¸ê®ÆªºEXCELÀÉ
¥Ø«e¥i¥H§Q¥ÎWINDOS¦Û°Ê°õ¦æ
¦ý¤@ª½µLªk±N¸Ì­±ªºVBA§ï¦¨¦Û°Ê°õ¦æ
¤w¸g¸Õ¹Lºô¸ô¤W«Ü¦h¤èªk
¤]°Ý¹L¤@¨ÇªB¤Í
ªB¤Í¥u»¡¼gªk©Ç©Çªº
¦]¬°§Ú¤£¤jÀ´VBA.....
§Ú§âµ{¦¡¤º®e¶K¤W¨Ó

§ÚÀ³¸Ó­n«ç»ò¼g¤~¯à¦Û°Ê°õ¦æ
¥t¥~¦pªG§Ú·Q­n¦b«ü©w®É¶¡Ãö³¬³o­ÓÀÉ®×
µM«á¥t¦s·sÀɦb§Ú«ü©wªº¸ê®Æ§¨
¤S¸Ó«ç»ò¼g
½Ð¦U¦ì°ª¤âÀ°¦£...............ÁÂÁÂ!!!
cow

¦^´_ 1# Ô£ªF¦è
§Aªº°ÝÃD¬O»¡­n±N¦¹ÀÉ®×¥[¤JWindowsªº¤u§@±Æµ{§a
­n¶}±ÒÀÉ®×·íµM­n¥ÎWindowsªº¤u§@±Æµ{¡AµLªk¥H¦Û¤vªºVBA±Ò°ÊÀÉ®×
¦]¬°¦¹Àɮצb¥¼¶}±Ò«e¡AVBA¬O¤£¥i¯à¦Û¤vŪ¨ú°Ê§@ªº
·í¶}±Ò«á­n¦Û°ÊÃö³¬·íµM´N¥i¥H¥Î³oÀÉ®×¥»¨­ªºµ{¦¡½X¨Ó°µ¥t¦s©ÎÃö³¬

¤£ª¾¹D§Ú¹ï§Aªº°ÝÃD²z¸Ñ¬O§_¥¿½T?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Ô£ªF¦è ©ó 2013-1-12 00:20 ½s¿è

¦^´_ 2# Hsieh


©êºp~¥i¯à§Ú°Ýªº¤è¦¡¿ù¤F
§Úªº·N«ä¬O§Ú¥i¥H§Q¥ÎWINDOS±Æµ{¥´¶}EXCELÀÉ
¥´¶}«á§Ú·Q­n¥i¥H¦Û°Ê°õ¦æ¸Ì­±¼g¦nªºVBA
¤£»Ý­n§Ú¦A¥h«ö°õ¦æ¯Ã
§Ú¤]ª¾¹D¥i¥H§Q¥Îµ{¦¡¦Û°ÊÃö³¬¨Ã¦sÀÉ.....
§Ú¦³§ä¹Lºô¸ôªº¸ê®Æ
¦ý´N¬OµLªk®M¥Î¨ì§Ú²{¦bªºµ{¦¡¸Ì­±
¦]¬°§Ú¦Û¤v§Ë¤£¥X¨Ó
©Ò¥H·Q½Ð¤j®aÀ°¦£
¦b²{¦³ªºµ{¦¡¸Ì§ÚÀ³¸Ó«ç»ò­×§ï
©ÎªÌ¬O­n¥þ³¡­«¼g
¦pªG¥þ³¡­«¼g·|¤ñ¸û¤è«Kªº¸Ü
§Æ±æ¦³µ½¤ß¤H¤h¥i¥HÀ°¦£.......
cow

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-1-12 00:32 ½s¿è

¦^´_ 3# Ô£ªF¦è
¨º´N¬O§Q¥ÎOPEN¨Æ¥óµ{§Ç°Ï°Ê
2#¦^´_ªº¹Ï¤¤¬O¼g¦b¤@¯ë¼Ò²Õ¤ºªº
Sub Auto_Open()
»PThisworkbook¼Ò²Õ¤ºªº
Private Sub Workbook_Open()
¬O¦P¼Ë·N«ä¡A´N¬O¦b¶}±ÒÀɮ׮ɷ|°õ¦æ¸Óµ{§Ç¤ºªº±Ô­z
¤]´N¬O§A§â«ö¶sªºµ{¦¡¼g¨ì³o­Óµ{§Ç¤º´N·|¦b¶}Àɮɰõ¦æ¤F
­YÁÙ¬O¤£À´¡A½Ð¤W¶ÇÀɮרӻ¡©ú§Aªº»Ý¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Ô£ªF¦è ©ó 2013-1-12 01:02 ½s¿è

¦^´_ 4# Hsieh


¥i¥H¤F
³o­Ó°ÝÃD§xÂZ¤F§Ú¦n¤[.....
¥i¬O¦³·s°ÝÃD.....
­n«ç»ò°±¤î........07ªºEXCEL§Ú§ä¤£¨ì..........
²{¦b¶}±Ò·|¦Û°Ê°õ¦æ¤F
¦]¬°­è­è¦A§â§Aªº¹Ï¸Ì­±ªºµ{¦¡¼g¥X¨Ó
©Ò¥Hªá¤F¤@ÂI®É¶¡
·PÁª©¥D!!·P¿E¤£ºÉ!!
cow

TOP

¦^´_ 5# Ô£ªF¦è

©êºp....
¦A½Ð±Ð¤@­Ó°ÝÃD
#2¸Ì­±ªº¤½¦¡À³¸Ó¬Oª½±µ¦sÀÉ
¨º¦p¦ó¥t¦s·sÀɦb§Ú«ü©wªº¸ô®|©O?
ÁÙ¬O§Úª½±µ¤W¶ÇÀÉ®×
µM«á»¡©ú§Úªº»Ý¨D
¥i¥Hªº¸Ü½Ðª©¤jª½±µÀ°§Ú­×§ï
ÁÂÁÂ
cow

TOP

¦^´_ 6# Ô£ªF¦è


³o¬OÀÉ®× dde.rar (19.32 KB)
¦pªGª©¤j¦³ªÅªº¸Ü
ÁÂÁÂ!
cow

TOP

°ÝÃD¤w¸Ñ¨M......
¦ý§Ú¤£ª¾¹D«ç»ò§R°£¸Ó©«©Î¬O¦b§Úªº¥DÃD«á­±¥[¤W¤w¸Ñ¨M
¥i¥H½Ðª©¥DÀ°¦£¶Ü
cow

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD