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

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

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

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-9-19 23:53 ½s¿è

vba±M®×¤£¥i¨£ªº¤è¦¡»P­ì²z
­ì²z: §Q¥ÎEXCEL95ª©¨S¦³ IsAddin¥\¯àªºBUG¡A§Ú­Ì¨Ï¥ÎEXCEL97¥H¤Wª©¥»±N¦³¥¨¶°ªºÀÉ®×°µ IsAddin=True¡AµM«á¦A¦s¦¨EXCEL5.0/95®æ¦¡¡A¥H¦¹°µªk¥i°µ¦¨[vba±M®×¤£¥i¨£]¡Aªü¦N2000~2008¦~¶¡¥H¦¹­ì²z»Pµ{¦¡¨¬¥H »P ¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©] ¥­¤À¬î¦â¡A¦ý¦¹­ì²zºô¤W¤Ö¦³¥B¤£´¶¹M¡A¹ï³\¦h°ª¤â¨Ó»¡¡A¬O¨ä·d¤£²M·¡¥B¯«¯µªº°µªk¡A²{¦b±N¼W¯q¶°¤u¨ãµ{¦¡¤½¶}

¾A¥Î³nÅé:Excel2003ª©¥H¤U

¯S¦â: ¤@¯ëªº³nÅé »P ¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©] ¯}¸Ñ¤£¶}

³o­Ó¤u¨ã¬O ¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©] µo®i«e¡Aªü¦N¤â¤¤¥Î¨Ó»s§@ [vba±M®×¤£¥i¨£] ªº¼W¯q¶°¤u¨ã¡A¬O¦hºØ[vba±M®×¤£¥i¨£]¤èªk¨ä¤¤¤@ºØ
´N§Ú©Òª¾´N³æ¯Â¥u¬O­ì²z¤£¬O¤u¨ã.¦Ü¤Ö´N¦³¦hºØ­ì²z¡A³o¬O¨ä¤@[Âà¶K] vba±M®×¤£¥i¨£ ¦Ü¤Ö¦³4ºØ­ì²z

OLDVBALOOK.rar (7.58 KB)

p.s.ÀHµÛ¬ì§Þªº¶i¨B excel5.0/95 ¦b Excel2010µLªk¨Ï¥Î¦¹¤u¨ã¤]¦¨¬°ªü¦Nªñ´Á±Ë±óªº¤@¶µ§Þ³N
¤£¹L¦pªG±z§Y±NÂ÷¶}³æ¦ì©Î¤½¥q.¨Ï¥Î¦¹¤u¨ã¨Ó«OÅ@VBA ¬O­Ó¤£¿ùªº¿ï¾Ü.¦]¬°¥u­n¤½¥q´«Excel2010ª©¥H¤Wª©¥»¡A¨Ï¥Î¦¹­ì²z«OÅ@¹LªºÀÉ®×´N¤£¯à¥Î¤F

¤£¬O«ÜÀ´¡A¦ý¤@ª½³ßÅw¥Î2003ª©¡A¾Ç²ßª©¥DªººëµØ¡C

TOP

ªü¦N¥S:
    ±¡°Ý¥»¼W¯q¶°¾A¥Î³nÅé:Excel2003ª©¥H¤U¡A¤SExcel2010µLªk¨Ï¥Î¦¹¤u¨ã¡A¤£ª¾Excel2007­n¦p¦ó¨Ï¥Î¥»¼W¯q¶°¡AÁÂÁ¡C
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-18 11:37 ½s¿è

VISTA »P OFFICE2007¡AÀ³¸Ó¬O·L³n±À¥Xªº²£«~¤¤³Q©ß±óªº³Ì§Öªº¶¥¬q©Ê³nÅé
¬Æ¦Ü«Ü¦h¤HÄ@·N¨Ï¥Î XP »P OFFICE2003¡A¤]¤£Ä@·N¨Ï¥ÎVISTA »P OFFICE2007
VISTA »P OFFICE2007§Ú¥u¥Î¤F¤j·§1 ¦~¦h´N´«2010¡A²{¦b¤£¨ì1¦~¤S¦³2013ª©¤F
EXCEL 2007¥H¤Wª©¥»¦s¦¨ 5.0/95®æ¦¡®É.¥¨¶°·|³Q²¾°£¡A©Ò¥H¤~»¡¬O§޳N

¥H«eª½±µ¥Î¤â°Ê¾Þ§@¡A°O±o97~2003¥i¥H°µ
1.¨ú¤@­Ó¦³¥¨¶°ªºÀÉ®×
2.¦s¦¨EXCEL5.0/95®æ¦¡
3.ÀÉ®×°µ IsAddin=True
3.µM«áÃö³¬EXCEL¥L·|°Ý§A­n¤£­n¦sÀÉ¡A¿ï¦sÀÉ
¤W­z´N¬O¤â°Ê­ì²z

§ޥ©¤F¡A©Ò¥H¤]¨S¦A¥[¤W§PÂ_ª©¥»¡A¦³¿³½ì±z¥i¥H°Ñ¦Ò¬Ý¬Ý

TOP

ªü¦N¥S:
    ²×©ó§¹¦¨¤F¡u¦s¦¨EXCEL5.0/95®æ¦¡¡v¡A¦n¤jªº¤uµ{§r¡I¥i¬Othis workbook Äݩʧאּ IsAddin=True«á¡AµLªk¦sÀÉ¡A¬O¤£¬O§Úº|¤F¨º­Ó¨BÆJ¡AÁÂÁ¡C
Lin

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-18 12:06 ½s¿è

§âEXCELÃö±¼¡AEXCEL´N·|»¡­n¤£­n¦sÀÉ
«ö¦sÀÉ´N¦n
¦ý¦sÀɮɷ|²¾°£VBA §A³o¼Ë¦sÀɮڥ»¨S¥Î¡AµLªk°µ¦¨VBA±M®×¤£¥i¨£»PÂê©w

TOP

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

¥Î³o¤äVBAÂà´«µ{¦¡.¦w¸Ë«á2007/2010¥i¥H¨Ï¥Î¦¹¼W¯q¶°

¦bEXCEL2010 ­n¦s¦¨ EXCEL5.0/95®æ¦¡·|¶]¥X³oµe­±¡A¦sÀÉ«áVBA¥¨¶°·|³Q²¾°£

³o¬O·L³nªº¦^ÂÐ:¨t²Î­n¨D±z Microsoft Office ½u¤W ¡u VBA Âà´«µ{¦¡ ¡v ®É¡A·j´M±z¹Á¸Õ¶}±Ò©ÎÀx¦s Excel ¬¡­¶Ã¯
·L³n´£¨Ñ¤F Hotfix ¥i¨Ñ¤U¸ühttp://support.microsoft.com/kb/926430/en-us

ªþµù¡u ¤U¸ü Hotfix ¡v ªí³æ·|Åã¥Ü¦¹ Hotfix ·|¥X²{¡A¥H¨Ñ¨Ï¥Îªº»y¨¥¡C¦pªG±z¨S¦³¬Ý¨ì±zªº»y¨¥¡A¬O¦]¬°¦¹ Hotfix ¬O¤£¾A¥Î±zªº»y¨¥¡C

¦ý§Ú«Øij¤£­n¨Ï¥Î¦¹¤U¸üªºµ{¦¡
­ì¦]¦b©ó³q¥Î©Ê °µ¥X¨ÓªºªF¦è ¨ä¥L¹q¸£¤£¯à¨Ï¥Î¡A°£«D¦A¦w¸ËVBAÂà´«µ{¦¡.µ{¦¡·|¨ü­­

°£«Dp.s.ÀHµÛ¬ì§Þªº¶i¨B excel5.0/95 ¦b Excel2010µLªk¨Ï¥Î¦¹¤u¨ã¤]¦¨¬°ªü¦Nªñ´Á±Ë±óªº¤@¶µ§Þ³N
¤£¹L¦pªG±z§Y±NÂ÷¶}³æ¦ì©Î¤½¥q.¨Ï¥Î¦¹¤u¨ã¨Ó«OÅ@VBA ¬O­Ó¤£¿ùªº¿ï¾Ü.¦]¬°¥u­n¤½¥q´«Excel2010ª©¥H¤Wª©¥»¡A¨Ï¥Î¦¹­ì²z«OÅ@¹LªºÀÉ®×´N¤£¯à¥Î¤F

TOP

¨Ï¥Î¦¹¼W¯q¶°»s§@¥XªºVBA±M®×«OÅ@ÀÉ®×

ª½±µ«ö¦sÀɮɷ|¤£¯à¦sÀɦp[­ì³Ð] ±zµLÀx¦s³Q«OÅ@ªºVBAProject

¦¹®É§âISADDIN=FALSE.Åã²{¬¡­¶Ã¯¡A¦A¥t¦s¦¨³Ì·sÀɮ׮榡 ¦p 'EXCEL97-2003®æ¦¡ OR XLSM®æ¦¡ ´N¥i¥H¦sÀÉ

TOP

ªü¦N¥S:
    °õ¦æ¡uvba±M®×¤£¥i¨£-oldvba¤èªk»POLDVBALOOK¼W¯q¶°¡v«á¡A¹F¨ìµøµ¡ÁôÂáA¦ý¦p¦ó¸Ñ°£VBAProject«OÅ@Âê©w¡A¦hÁ«ü±Ð¡C
Lin

TOP

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

¦^´_ 9# lin

³oºØVB±M®×Âê©w¸Ñ°£¤èªk¡A¥D­n¦³¨âºØ

1.Âà´«ªk: §â¤w¥Î¦¹ªkÂê©wªºEXCELÀÉ®× ¶}±Ò«á°µ isaddin=false¡A¥t¦sÀɮ׬° 97-2003®æ¦¡¡A¦A¥Î[vba¥[Âê¸ÑÂê¾¹]¸Ñ°£vba±M®×¤£¥iÀ˵ø¡A´N§¹¦¨¸Ñ°£(³o¬O³Ì±`¨£ªº¤è¦¡)

2.¤@¯ë¥Îªk:§â¤w¥Î¦¹ªkÂê©wªºEXCELÀÉ®× ¶}±Ò«á°µ isaddin=false¡A¥t¦sÀɮ׬° 97-2003®æ¦¡¡A¦A«OÅ@¥B¦@¥Î¬¡­¶Ã¯¡AµM«á¦A¨ú®ø«OÅ@¥B¦@¥Î¬¡­¶Ã¯¡A´N§¹¦¨¸Ñ°£(³o¬O¤£±`¨£ªº¤è¦¡¡A¥u¦³³o¤èªk¤~¥i¥Î) ¥Î³o­Ó¤èªk¸Ñ°£¡A¦A¥[¤W«e©«¤â°Ê­ì²zÂê©w¡A®Ú¥»¤£»Ý­n¥ô¦ó¤u¨ã´N¥i¾Þ§@¦¹§Þ¥©¡A©Ò¥Hªü¦N³ßÅw¦¹§Þ¥©¡A¦]¬°¤£¥Î±a¤u¨ã

¥H¤W¤èªk´N¥i¥H¸Ñ°£¦¹ªkªºvba±M®×¤£¥iÀ˵ø

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD