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

[µo°Ý] «OÅ@vba·½½Xªº¤èªk±´°Q

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2016-5-31 12:13 ½s¿è

2003ª©¬O¦³¤èªk±j¨î±Ò¥Î¥¨¶°, ¤£±Ò¥Îª½±µÃö³¬ÀÉ®×,
¨ä¥¦ª©¥»´N¤£ª¾¹D¦p¦ó³]¸m!!!

·Q¥HVBA½æ¿ú, ¤j·§´Â¦V¨Ì¤£¦P»Ý¨D¦Ó«È»s¤Æ, «ÜÃø¥H¤@®Mµ{¦¡¥´¨ì©³,
¦óªpOFFICE¤Î§@·~¨t²Îª©¥»§ïª©§Ö³t, ­n¥hºûÅ@µ{¦¡ªº¬Û®e©Ê, «Ü²Ö¤H~~~

TOP

¥»©«³Ì«á¥Ñ ketrddem ©ó 2016-5-31 21:02 ½s¿è

¦^´_ 11# ­ã´£³¡ªL


  ²`¦³¦P·P¡Cª©¥»ªº¤£¦P¡A¦³®É¬Û¦Pªº»yªk«oµLªk°õ¦æ¡A«Ü¥O¤HÀY¯k.....

¥t¥~½Ð±Ð³¡ªL¤j­ô
¦³µL¤èªk¯à¥ÎVBAºÊ´úVBEµøµ¡³Q¶}±Ò©O¡C

¦pªGºÊ´úVBEµøµ¡³Q¶}±Ò¡A¨ä¹ê´N¦³¿ìªk°µ«áÄò°Ê§@¤F(¤ñ¦p¡G ¥»¤å¥ó§Y±N¦Û§Ú§R°£)
EXCEL VBA·s¤â¡A½Ð«e½ú¦h¦h«ü±Ð

TOP

½Ð±Ð¡ALockxls§âExcelÅܦ¨exe¡A°õ¦æ®Ä²v·|ÅܨζÜ?

TOP

¥»©«³Ì«á¥Ñ ketrddem ©ó 2016-6-8 23:09 ½s¿è

¦^´_ 13# rocky.gary


¤£ª¾¹D­C¡C

¦ý¤p§Ì·Q¨ì¤@­Ó¤èªk¡A¤£ª¾¥i¤£¥i¦æ¡C·Q§Q¥Î®É¶¡¨Ó¸Õ¸Õ¬Ý¡C

¦³Å¥¹L«öÁäºëÆF³o®M³nÅé¶Ü?

´N¬O¨âªÌ¤¬±±

excel¨C¤T¬í§ì«öÁäºëÆFµ¡¤f¡A¥u­n«öÁäºëÆFµ¡¤f®ø¥¢¡Aexcel ´N¦Û°ÊÃö³¬¡C(·N«ä´N¬O­n±j¨î¥Ñ«öÁäºëÆF¨ÓºÊ±±EXCEL)¡C

«öÁäºëÆF¨C¤T¬í§ìVBEµ¡¤f¡C¥u­n§ä¨ìµ¡¤f¡A¦Û°ÊÃö³¬EXCEL¡C(³oª¬ªp¡A´Nºâ¶}±ÒEXCEL¡A³]©w¦b³]­p¶¥¬q«á¦A¥´¶}VBE¡AÃö³¬EXCELªº°Ê§@¬O¥Ñ«öÁäºëÆF°õ¦æªº)¡C

¶}±ÒEXCEL®É¡A¦Û°Ê±Ò°Ê«öÁäºëÆF¡C

³o¥u¬O·§©À¡A¯uªº¼g¥X¨Ó¡A¬Û«H·|·l¯Ó¤£¤Ö¨t²Î¸ê·½¡C

¤£ª¾ª©¤W°ª¤â­Ì¡A¯à¤£¯à¥ÎÃþ¦ü³oºØ·Qªk¡Aª½±µ¼g¤@­Ó§å¦¸ÀÉ´N¯à¨ú¥N«öÁäºëÆF©ÎVBEµ¡¤f©O¡C¥Î§å¦¸ÀɨӺʱ±¡C
EXCEL VBA·s¤â¡A½Ð«e½ú¦h¦h«ü±Ð

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2016-6-26 13:48 ½s¿è

ºîÆ[°ê¤º¥~¡A³o°ÝÃD¡A¥u¦³ªü¦N§@¥X³Ð·s¡A¸Ñµª¡A¦³¤èªk
¨Ã­ºµo¦b³Â»¶

¥Ø«e«OÅ@VBAµ{¦¡ªº¤èªk¤£¦h
1¡A»s¦¨exe/dll¡Avbs¡A¦ý·|³Q§P¬°¯f¬r¡A¥BµLªk¦sÀÉ¡A¤£¨Î

2¡AVBA±M®×¤£¥iÀ˵ø
2002¦~¥´«¢¤íªº¤èªk

3¡A¦@¥Î¬¡­¶Ã¯¡AVBA±M®×¤£¥iÀ˵ø
EXCEL­ì©l¥\¯à

4¡A95/5.0 VBA±M®×¤£¥iÀ˵ø
³o¬O°ê¥~¶Ç¤Jªº¤èªk

5¡AVBA¼Ò²ÕÁôÂÃ

VBA±M®×Âê©wªº¯}¸Ñ¤è¦¡¦bºô¸ô¤W»POFFICE¬ÛÃöªÀ¸s½×¾Â¤¤·¥¬°´¶¹M¡A¥H·L³nExcel VBA±M®×µ{¦¡½X«OÅ@»P«O±K¬°¬ã¨s¹ï¶H¡Aµo®i¥X·sªºVBAµ{¦¡½X«OÅ@»P«O±K¤èªk¡A¥Î¥H¨¾¤î­«­n¤å¥óVBAµ{¦¡½X³Q«DªkÅѨú¤Î¿sµø¹B¥Î¼Ò²ÕÁôÂíì²z»s§@¦¨¼Ò²ÕÁôÂÃExcel¼W¯q¶°¤u¨ã¡C«áÄò«ùÄò´ú¸Õ·L³nExcel¤G¶i¦ìÀɮ׮榡¡A§@¡u³¡¤À¼Ò²ÕÁôÂáv»P¡u¥þ³¡¼Ò²ÕÁôÂáv¬O§_¾A¥Î¦bExcel¦Uª©¥»¡Aµo²{·í¥þ³¡¼Ò²ÕÁôÂîÉExcel 2003ª©¥i³q¹L¥¨¶°¦w¥þ©Ê¡A¦¹¯S®í®ÄªG±N³y¦¨Excel 2003¦w¥þ©Ê¤WªºÅU¼{¡A´c·Nªºµ{¦¡³]­p¤H­û¥i¥H§Q¥Î¦¹µ{¦¡º|¬}¡A¹ï¹q¸£¶i¦æ­×§ï»P¯}Ãa¡C¦b´£¤ÉMicrosoft Excel VBA±M®×«OÅ@½ÆÂø©Ê¸ÕÅç¹Lµ{¤¤¡AÃÒ¹êVBA±M®×Âê©w¦b¥[±K»P¸Ñ±K«á§¡¥i¶¶§Q·f°t¼Ò²ÕÁôÂÃ¥B¥¨¶°¥i¥¿±`¨Ï¥Î¡A´ú¸Õµ²ªG½T»{¥i¥H¨Ï¥ÎVBA±M®×¤º¥~¨â¼h¨¾Å@¡A¨Ó´£¤ÉMicrosoft Excel VBA±M®×µ{¦¡½X«OÅ@«O±K½ÆÂø©Ê¡C¬ã¨s¤¤µo²{¥þ³¡¼Ò²ÕÁôÂîɱN³y¦¨Excel 2003¦³¦w¥þ©Ê¤WªºÅU¼{¡A«ØijExcel¨Ï¥ÎªÌÀ³ºÉ¦­¨O´«Excel 2003¡A¨Ã¨Ï¥ÎExcel 2010¥H¤Wª©¥»¡A¤~¥i¥H§ó¦w¥þªº¨¾Å@´c·NÀÉ®×»Pµ{¦¡ªº§ðÀ»¡C


¥Ø«e¥H2¡A5¶µ¤èªk³Ì¦n¥Î

TOP

¦^´_ 15# HUNGCHILIN


    ªü¦N¤j¤j±z¦n,±z¤@­È³£¬O³o¤è­±ªº±M®a
·Q½Ð±Ð¤@¤U¡A±z¤W­z´£¨ìªº2¡B5ªº¤è¦¡,¬O§_¦³¬ÛÃöªºµ{¦¡½X¥i¥H¤À¨É©O?
¥H¤Î¤@¥¹ÁôÂ䧫á¤S­n¦p¦ó¤~¯àºûÅ@VBAªºCODE©O?
PKKO

TOP

¦^´_  ketrddem
¦³¿³½ì¥i¥H°Ñ¦Ò¤j®vªº¬ã¨s
stillfish00 µoªí©ó 2016-5-30 10:51


¨S¦³¤°»ò¥Îªº¡A¥L¥Ø«e®³¥X¨Óªº¤è®×©M´ú¸ÕÀɮצ­´N³Q¯}¸Ñ¤F¡C

¶¶«K¦b³o¸Ì´£¿ô¤@¤U¼Ó¥D¡G¤£¥Î¦A³o¤è«K¬ã¨s¤F¡A³£¨S¤°»ò«Ü¤jªº·N¸q¡C§Ú¥i¥H³o»ò»¡¡G§Ú¥i¥H¦b¨S¦³¦w¸ËOfficeªº¨t²Î¤¤ª½±µ§âExcelÀɮפ¤ªºVBA±M®×¥N½X¥þ³¡§¹¾ãªº´£¨ú¥X¨Ó¨Ã¼g¤J·sªºÀɮפ¤¡A¥]¬A³Q³]¸m¤FVBA±M®×±K½Xªº©Î¬O¨Ï¥Î¹LÁôÂÃVBA¼Ò¶ôªº¥N½X¡C¤£¹L¨Ï¥Î±M¥Îµ{¦¡§âExcel¤åÀÉ¥[±Kªþ¥[¦bEXE¤åÀɤ¤µyµy³Â·Ð¤@ÂI¡A¤£¹L¦b¦w¸Ë¦³¥»¤H±M¼gªºAddin¤u¨ãªºOffice¤¤ÁÙ¬O¥i¥H¯}¸Ñ±¼¤j³¡¤À«OÅ@¡C
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

¥Ø«e¥Hª¾³Ì¦w¥þªº¤èªk¬O±NVBA¥N½XÂà´«¦¨VB6©Î¬OC++¥N½X½sĶ¦¨¥»¦a¥N½X¡C«K­nª`·Nªº²{¦æMicoroft±ÀÂ˪º¬OVSTO¡A¦ý¬O³Ì¦n¤£­n¨Ï¥ÎVS½sĶ¡A¦]¬°VS¥»¨­¤]¬O¯à³QÁÙ­ì¥N½Xªº¡K¡K
¥@¬É¨º»ò¤j¡A¥i§Ú·Q¥h­þ¡H

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD