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

[­ì³Ð] vba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°

ªü¦N¥S:
         ¤£¦n·N«ä§Ú©ó°õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v«á¡AµLªk±NÂê©wªºEXCELÀɮ׶}±Ò¡A¤]´NµLªk¶i¤JVBE¤¤§ó§ïÄÝ©Ê¡C
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-19 01:04 ½s¿è

¦^´_ 11# lin
³o¬O²³æªºÅã¥Ü¤èªk...¤£¥Î¯}¸Ñvb±M®×´N¥i¥H¾Þ§@
¥ý­É§Oªº¬¡­¶Ã¯ªºvb¼Ò²Õ·í´ß©ñ¶i¥h°õ¦æ´N¥i¥H
Sub IsAddinFalse()
Workbooks("BOOK1.xls").IsAddin = False
End Sub

TOP

ªü¦N¥S:
       ©Ó»X«ü¾É¡A¸U¤À·PÁ¡A°õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v¡A¶}±ÒÀɮקó§ïÄÝ©Ê«á¦A¥t¦s¦¨³Ì·sÀɮסA²£¥ÍºÃ°Ý¦³¤T¡G
1.­«¶}±Ò«á¤£¯à¨£¥»ÀÉ®×¥¨¶°¡A¤]¤£¯à²K¥[¥¨¶°¡C
2.Active±±¨î¶µ¡B¥\¯àªí©R¥O¹Ï¥Ü¡Buserform¤ÎExcel4.0µLªkÂà´«¡C
3.°ßŪÀɮסBVBCProject¥[±K«á¤]µLªkÂà´«¡C
Lin

TOP

¦^´_ 13# lin


    ªü¦N¥S:
        ©Ó»X«ü¾É¡A¸U¤À·PÁ¡A°õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v¡A¶}±ÒÀɮקó§ïÄÝ©Ê«á¦A¥t¦s¦¨³Ì·sÀɮסA²£¥ÍºÃ°Ý¦³¤T¡G

ANS:
1.³o¬Ovba±M®×¤£¥i¨£ªº¤èªk¤§¤@.­«¶}±Ò«á·íµM¤£¯à¨£¥»ÀÉ®×¥¨¶°¡A¤]·íµM¤£¯à¤£¯à²K¥[¥¨¶°¡C­n¤£°µ³o¥\¯à°µ¬Æ»ò
2.³o¬O¨Ï¥ÎEXCEL5.0ªº§@ªk¡A·sªº¥\¯à¦puserform·íµMµLªk¨Ï¥Î
3.³o­Ó§Ú¨ä¥L¶K¦³»¡¹L¤F¡A°ßŪÀɮץΦ¹¤èªk©ÎVBA¥[Âê¸ÑÂê¾¹³£¤£¯àª½±µ°µvba±M®×¤£¥i¨£Âê©w»P¯}¸Ñ¡A°£«D¥ý¸Ñ°£°ßŪ¦b°µ

TOP

ªü¦N¥S:
        ¥i¯à§Úªºªí¹F¦³»~¡A§Ú¬O·Q°Ý°õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v¡A¶}±ÒÀɮקó§ïÄÝ©Ê«á¦A¥t¦s¦¨³Ì·sÀɮסA¬O§_¥i¥H¸ÑÂê²K¥[¥¨¶°¡C
Lin

TOP

¦^´_ 15# lin


    ¸ÑÂê«á¬O¥i¿ý¨î»P¼W¥[¥¨¶°¡A±z¦³·Ó¤W­±§¹¦¨¯}¸Ñ¡A¸Õ¸Õ´Nª¾¹D

TOP

ªü¦N¥S:
      °õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v¡A¶}±ÒÀɮקó§ïÄÝ©Ê«á¦A¥t¦s¦¨³Ì·sÀɮסA§Ú¸ÕµÛ¦boffice 2007©Îoffice 20035¤¤Âà¦^­ìÀÉ®×¥H«K§ó§ï¥¨¶°¦ý¡A¤´µLªk¿ì²z:
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-2-6 13:42 ½s¿è

¦^´_ 17# lin

§Ú¥i¥H½T©w±z¨S¦³±M¤ß¬Ý²Ä#8¡B#10©«¡AVBAÂê©w¤]¨S¯}¸Ñ¶}¨Ó¡A¤~¤@ª½­«½Æ°Ý¦P¼Ëªº°ÝÃD
§Ú·Q½Ð±z¥ý¥Î#10©«ªº¤èªk 1 ©Î¤èªk2 ¥ý°µ¤@¦¸¡A«e­±¨º´X©«±z³£¥u°µ¤@¥b¡A®Ú¥»¨S·Ó #10ªk1ªk2 °µ

±z¦s¦¨97-2003®æ¦¡«á.¦³¦A¥Î VBA±M®×¥[Âê¸ÑÂê¾¹ ¦A°µ¤@¦¸¸ÑÂê¶Ü?(ªk1)¡A©ÎªÌ °µÂê©w¦@¥Î¬¡­¶Ã¯¡A¦A¸Ñ°£Âê©w¦@¥Î¬¡­¶Ã¯(ªk2)
±z«á¥b¬q¨BÆJ³£¨S°µ¯à¯}¸Ñ?ªP¶O§Ú#10©«¥´¨º»ò¦h¦r¡A³£¨S¦b¬Ý

·Ó¤W­z°µ±z¨ì©³¥d¦b­þÃä?
*¨S°µLWorkbooks("BOOK1.xls").IsAddin = False?
*¨S¥t¦sÀɮ׬° 97-2003®æ¦¡ OR XLSM?
*¨S¦A¥Î VBA±M®×¥[Âê¸ÑÂê¾¹ ¦A°µ¤@¦¸¸ÑÂê¶Ü?(ªk1)¡A©ÎªÌ °µÂê©w¦@¥Î¬¡­¶Ã¯¡A¦A¸Ñ°£Âê©w¦@¥Î¬¡­¶Ã¯(ªk2)?

#13~#17³£¬O­l¦ù¥X¨Óªº¨S¦³¥Îªº©«

TOP

ªü¦N¥S:
±z©Ò´£10©«ªº¤èªk 1 ¡§¦A¥Î[vba¥[Âê¸ÑÂê¾¹]¸Ñ°£vba±M®×¤£¥iÀ˵øÂê¾¹]¡¨¡A§Ú¦³¸Õ°µ¦h¤é¡A¦ý¤´¤£±o¨ä¸Ñ¡F¬Q¤é¬Ý¨ì±zªº¶K¤å«á¡A·Q·Q¥i¯à¬O¦WÃã»~¸Ñ¡A§Ú¬d¡u[¤À¨É] ¦p¦ó¦b¨S¦³¥ô¦ó¤u¨ã¤U·s¼W»P¸Ñ°£VBA¤w³QÂê©w_±M®×µLªkÀ˵ø(¦@¥Î¬¡­¶Ã¯)¡v²Ä6©«1."VBA±M®×¥[¸ÑÂê¾¹" ¦p:http://forum.twbts.com/viewthread.php?tid=70&extra=¡A¤U¸ü¨Ã¨Ï¥Î¡uVBA±M®×²©ö¥[¸ÑÂê¾¹¡vµL®Ä¡A¤èÅצh¦¸¸ß°Ý¡A½Ð½Ì¸Ñ¡C
¤µ¤Ñ§Ú¨Ì¡uvba±M®×¤£¥i¨£ ¦Ü¤Ö¦³4ºØ­ì²z¡v¤¤²Ä1©«¡u¤G¶i¦ì¬¡­¶Ã¯ ¶W»ÅVBA¤uµ{¥[Âê¸ÑÂê¾¹[ldhyobª©]http://www.officefans.net/cdb/vi ... d=15681&fpage=1¡v¡A¯àµù¥U¦ý¤£¯à¤U¸üªþ¥ó¡F«á¨Ó¦b¨ä¥Lºô¯¸¤U¸ü¡uVBA¤uµ{¥[¸Ñ锁¾¹(§¹¥þª©).xls¡v²Å骩¡A¦ý¤´µLªk¨Ï¥Î¡A¤£¹L§ÚÁÙ¬O·|¥t¥~·Q¿ìªk¡C
§Ú·Q¨C­Ó¤H¥i¯à¨ü­­©óµ{«×®t²§¡A©Ò¥H¤£¨£±o³£¬O¤£»{¯u¦ý¤S·R¶Ãµo°Ý¡A¤×¨ä¬O§Ú¦~»´®É¤]¦b°ª¤¤±Ð¹L®Ñ¡A§Ú¤£·|¤£À´³o­Ó¹D²z¡C·íµM¤£½×¥ô¦ó¤H´£¥XºÃ°Ý±z³£¦³µª©Î¤£µªªºÅv¯q¡A¦ý§Ú¥u¬O¤£§Æ±æ»~¸Ñ¡C
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-2-8 01:47 ½s¿è

©êºp¡A­«¨Ó¤@¦¸¡A§Ú­Ì¤£­n¥Î¥ô¦ó¤u¨ã¡A¯Â¤â¤u¨ÓÂê©w»P¸Ñ°£VBA±M®×¤£¥iÀ˵ø
Âê©w
1¡A±N¦³VBA ¥¨¶°ªºExcel ÀÉ¥t¦s¦¨95/5¡A0
2¡A±NÀÉ®×isaddin=true
3¡AÃö³¬ÀɮסA会¥X²{¬O§_¦sÀÉ¡A«ö¦sÀÉ¡A´N§¹¦¨

¸Ñ°£VBA ±M®×Âê©w
1¡A±N¤W­±»s§@ªºÀÉ¥´¶}
2¡A¶}·sExcel ÀÉ¡A¦b¼Ò²Õ¤º¶K¤J#12©«ªºµ{¦¡¡]¦¹µ{¦¡内¡AÀɮצWºÙ°O±o­n§ï¡^¡A°õ¦æµ{¦¡¡A±N¦¹Àɪºisaddin=False
3¡A¥t¦sÀɮצ¨97/2003®æ¦¡
4¡A«OÅ@¦@¥Î¬¡­¶Ã¯¡A¨Ã³]©w±K½X
5¡A¸Ñ°£«OÅ@¦@¥Î¬¡­¶Ã¯¡A´N§¹¦¨¸Ñ°£

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD