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

[Âà¶K] vba±M®×¤£¥i¨£ ¦Ü¤Ö¦³4ºØ­ì²z

[Âà¶K] vba±M®×¤£¥i¨£ ¦Ü¤Ö¦³4ºØ­ì²z

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-2-1 22:39 ½s¿è

发ªí¤_ 2006-12-16 11:58
http://www.officefans.net/cdb/viewthread.php?tid=66245
[¨D§U] ¨D§U HUNGCHILIN (ªü¦N)ªB¤Í
HUNGCHILIN (ªü¦N)
§A´£¨Ñªº¤å档¤@个¬O¥´开¦Z¥X现问题¡A¤@个¬O¸Ñ±K´£¥Ü无±K码¡AÚÌ实«Ü¦n¡A¯à§_赐±Ð¤_§Ú©O¡A§Ú¤£Ð`·P¿E¡C
还¦³,§Ú·Qª¾¹DÊI¤W¦³个©«¤l,¸Ñ±K¦Z¥´开,¤u§@ï´N¥X现乱码.¬O«ç¤\¦^¨Æ©O?ªþ©«¤l

------------------------------------------------------------------------------------------------------------------------------
¦^Î` 1# daitq7018
³o­Ó°ÝÃD¬O«Ü¦nªº°ÝÃD
¥Ø«eºô¸ô¤W¨ä¹ê¦³«Ü¦h vba±M®×¤£¥i¨£ªº¤è¦¡»P­ì²z
´N§Ú©Òª¾´N³æ¯Â¥u¬O­ì²z¤£¬O¤u¨ã.¦Ü¤Ö´N¦³¥|ºØ­ì²z
¤£¦P¤u¨ã»P³nÅé°µªk¥i¥H¦@¥Î¤@ºØ­ì²z.

¦Ó§Ú­Ì³Ì±`¥Îªº¤u¨ã¬O"¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©]"
Åý¤H¥H¬° vba±M®×¤£¥i¨£=¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹   ¥u¦¹¤@ºØ­ì²z°µ¦¨ªº¤@­Ó¤u¨ã?

´N§Ú©Òª¾­ì²z¦³:
1.¦@¥Î¬¡­¶Ã¯  ¬O¤@ºØ
2.oldvba¤èªk ¬O ¤@ºØ
¥Nªí§@«~:
¬O³o­Ópassword.xla ¨ì³o¤U¸ü´N¦³http://www.straxx.com/excel/password.html
³o©«¬O¦¹Ãþ«¬¶i¶¥À³¥Îhttp://forum.twbts.com/viewthread.php?tid=70&page=1&extra=#pid93

3.¤G¶i¦ì¬¡­¶Ã¯ ¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©]http://www.officefans.net/cdb/vi ... d=15681&fpage=1
4.¤G¶i¦ì¬¡­¶Ã¯ ½×¾Â¤º¨S¦³¦s©ñ¦¹VBA¤£¥iÀ˵ø¥Í¦¨µ{§Ç.

¤W­z4ºØ¬°¤¬¥¸.¨Ï¥Î®É¥u¯à¨Ï¥Î¤@ºØ.¤£¯à¤¬¥Î
¸Ñ°£vba±M®×¤£¥i¨£®É:
     ²Ä4ºØ¥i¸Ñ¥þ³¡ºØÃþvba±M®×¤£¥i¨£
     ²Ä3ºØ¥i¸Ñ°£1.3ºØ/¸Ñ²Ä2ºØ®É·|Åã¥Ü"±M®×¥¼Âê©w"¦ýÁÙ¬O¨S¸Ñ¶}/¸Ñ²Ä4ºØ®É¸Ñ¶}«á¼Ò²Õ·|¿ò¥¢©Î¨S¼Ò²Õ
          ©ÎÀÉ®×Åܦ¨¶Ã½X=¨S¸Ñ¶}¥BÀÉ®×Ãa±¼(¸Ñ°£«eµ{¦¡¥¿±`/¸Ñ°£«á¥¢±`)
     ²Ä2ºØ¥u¥i¸Ñ°£1.2
     ²Ä1ºØ¥u¥i¸Ñ°£1


¨ä¥¦½×¾Â(¦pEXCELHOME)¦³´X½g¤å³¹.
µo©«»¡¦³´X­ÓÀÉ ¸Ñ¶}vba±M®×¤£¥i¨£«á.¦b¤£¶}±Ò§»ªºª¬ªp¤U.
±M®×¤ºªº¼Ò²Õ·|¦Û°Ê§R°£.¬O«Ü¯S§O¥B©_©Çªº§Þ¥©?
¦b§Ú¬Ý¨Ó¯S§O¦n¯º.¥u¬O¥Î¿ù¸Ñ°£vba±M®×¤£¥i¨£¤èªk.³ºµM·|¦³¤W­z¸ÑŪ...

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

°£¤F¤W­z4ºØ¡A³oºØ¤è¦¡¥i¥H¬Ý¨ì±M®×¤ºªº¼Ò²Õ¡A¦ý¶i¤£¥h¼Ò²Õ»PSHEET»PTHISWORKBOOK¡AÂI¼Ò²Õ...µ¥¨â¤U¡A·Q­n¶iµ{¦¡°Ï·|¥X²{"±M®×µLªkÀ˵ø"¡A¥B«ö¥kÁäµLªkÂI¿ï"À˵øµ{¦¡½X"¡A¦p¹Ï:

±M®×µLªkÀ˵ø.jpg

2012-02-09 23-06-01.jpg

¥i¥H¥ÎVBA¥[Âê¸ÑÂê¾¹¯}¸Ñ

Book1.rar (4.39 KB)

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-2-16 21:18 ½s¿è

Ãö©ó4.¤G¶i¦ì¬¡­¶Ã¯ ½×¾Â¤º¨S¦³¦s©ñ¦¹VBA¤£¥iÀ˵ø¥Í¦¨µ{§Ç.

ª©¤º¨S¦³¦s©ñ¥Í¦¨µ{§Ç
¨ä¥Í¦¨ªºÀɮצpªþ¥ó

[­ì³Ð] Ãö©óºô¤W§¡¥¼°Q½×¹Lªº ²Ä¥|ºØ vba±M®×µLªkÀ˵ø¤èªk


¤U¸üÀɮ׫á¨Ï¥Î¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹¶i¦æ¯}¸Ñ.·|µo²{µLªk¯}¸Ñ.´N·|ÁA¸Ñ¨ä¤£¦P
3.¤G¶i¦ì¬¡­¶Ã¯ ¶W»ÅVBA¤uµ{¥[锁¸Ñ锁¾¹[ldhyobª©]
http://www.officefans.net/cdb/viewthread.php?tid=15681&fpage=1

TOP

¦^´_ 3# HUNGCHILIN


¤£¦n·N«ä·Q½Ð°Ý¤@¤U!!!®Ú¾Ú§A©Ò»¡ªº³Ì«á

©«»¡¦³´X­ÓÀÉ ¸Ñ¶}vba±M®×¤£¥i¨£«á.¦b¤£¶}±Ò§»ªºª¬ªp¤U.
±M®×¤ºªº¼Ò²Õ·|¦Û°Ê§R°£
.¬O«Ü¯S§O¥B©_©Çªº§Þ¥©?
¦b§Ú¬Ý¨Ó¯S§O¦n¯º.¥u¬O¥Î¿ù¸Ñ°£vba±M®×¤£¥i¨£¤èªk.³ºµM·|¦³¤W­z¸ÑŪ...

¨º¦pªG´«­Ó¤èªk»¡!!¬O¤£¬O»¡  ¦b¥i¯àªº±¡ªp¤U ¥u­n¿é¤J±K½X´N¯à°÷§â¾ã­Ó¸ê®Æ§R°£?

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-3-9 20:24 ½s¿è

¦^´_ 4# appr


    ³o¤@©«¥D­n¦b±Ô­z¦³¦hºØ¤èªk¥i¥H§Î¦¨¡@¡¨±M®×µLªkÀ˵ø¡¨¦p¤W¹Ï

¡¨±M®×µLªkÀ˵ø¡¨ªº¤èªk¥D­n¬O³z¹LÅܧó¤G¶i¦ìÀɮ׮榡¡D©Ò³y¦¨ªº¤@ºØ®ÄªG
¦pªG¨Ï¥Î¿ù»~ªºÅܧó¤G¶i¦ìÀɮ׮榡¤èªk¯}¸Ñ¡D±N·|³y¦¨ÀÉ®×·lÃa¡D¶i¦Ó¨Ï¼Ò²Õ»Pµ{¦¡¿ò¥¢
¬G«Ü¦hÀɮצb¡¨±M®×µLªkÀ˵ø¡¨¡@¢ä¢Ð¢Ï¥i¥H¥¿±`°õ¦æ
¯}¸Ñ«á¤Ï¦Ó¼Ò²Õ®ø¥¢
³oºØ¤èªk¥u¬O®æ¦¡ÅÜ´«»P¢ä¢Ð¢Ï¶}¤£¶}±ÒµLÃö
¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð
¦pªG¥u¨Ï¥Î¥¿±`ªº¸Ñ¶}±K½Xªº¤è¦¡¡D¦b¥¼¶}±Ò¥¨¶°ªºª¬ªp¤U¡D¥Ñ©ó¤£¬OÅܧó¤G¶i¦ìÀɮ׮榡¤èªk¡D¬GµLªk§Î¦¨§A©Ò»¡ªº®ÄªG

TOP

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

¦^´_ man65boy 2012-3-8 21:38

ªü¦N¦Ñ®v¡A¦A¦¸½Ð±Ð§A¡A¥H¤U¦Ñ®v©Ò³Ð§@ªºÀɮסA´N¬O(¶i¤£¥h¼Ò²Õ»PSHEET»PTHISWORKBOOK)¡A¬O§_¯à¦b«üÂI°g¬z©O?
·P¿E¤£ºÉ...¡C
http://forum.twbts.com/thread-5722-1-1.html

°£¤F¤W­z4ºØ¡A³oºØ¤è¦¡¥i¥H¬Ý¨ì±M®×¤ºªº¼Ò²Õ¡A¦ý¶i¤£¥h¼Ò²Õ»PSHEET»PTHISWORKBOOK¡AÂI¼Ò²Õ...µ¥¨â¤U¡A·Q­n¶iµ{¦¡°Ï·|¥X²{"±M®×µLªkÀ˵ø"¡A¥B«ö¥kÁäµLªkÂI¿ï"À˵øµ{¦¡½X"

---------------------------------------------------------------------------------------------------------------------------------------------

­º¥ý«Ü°ª¿³§A·|¹ï³o­ÓÀÉ»P«OÅ@¤è¦¡¦³¿³½ì

"±M®×¤£¥iÀ˵ø"¥Ø«e¦@¤À¦¨
1."±M®×¤£¥iÀ˵ø.(¤£¥i¬Ý¨£¤º³¡¼Ò²Õ/SHEET»PTHISWORKBOOK)
2."±M®×¤£¥iÀ˵ø.(¥i¬Ý¨£¤º³¡¼Ò²Õ/SHEET»PTHISWORKBOOK)
¨ä¤¤¶µ2´N¬O§A©Ò´£¥Xªº°ÝÃD......
¤W­z'¶µ1¶µ2¸g´ú¸Õ EXCEL2010ª©¥»¥i¥Î

¦¹ºØ¤èªk§Ú¤]ı±o«Ü©_©Ç.³o¤èªk©ú©ú10¦~«e´N¥i¥H´£¥X.¬°¤°»ò¨S¤H´£¥X¨Ó
­nµ¥¨ì²{¦b¦b¦¹´£¥X¨Ó.¥i¯à¤j®a³£«ÜÃi.­n·Q»P¥´¦r


TOP

¥»©«³Ì«á¥Ñ man65boy ©ó 2012-3-9 22:49 ½s¿è

¦^´_ 6# HUNGCHILIN
¤p§Ì¥u¬O¥ú¬Ý¨ì¦Ñ®vµoªí"±M®×µLªkÀ˵ø"ªº¤å³¹¡A±M·~ª¾ÃÑ¥H¥O¤H¶Ì²´¡A³ºµMÁÙ¦³²Ä2¶µªº"±M®×µLªkÀ˵ø"ªº¥\®Ä¡A(¥i¥H¬Ý¨ì±M®×¤ºªº¼Ò²Õ¡A¦ý¶i¤£¥h¼Ò²Õ»PSHEET»PTHISWORKBOOK¡A)¥O¤H§ó·P¿³½ì¡A½Ðªü¦N¦Ñ®v¯à«üÂI¤@.¤G¡C

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-3-12 22:43 ½s¿è

©È§A¬Ý¤£À´.¦³¼g¤ñ¸û²Ó

TOP

¦^´_ 8# HUNGCHILIN


    ·PÁªü¦N¦Ñ®vºë²Óªº¸Ñ»¡¡A¯u¬O¨ü¯q¨}¦h!

TOP

°O±o¥h¤U¤@­ÓÀH«Kªº ½s¿è³nÅé

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD