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

[­ì³Ð] ¦Û°Ê¦w¸Ë(¤£ªþ»¡©ú)Excel¨Ï¥ÎÂê¼W¯q¶°

§Ú¬O¥Î2003/2007ªºoffice
§Ú·Q­nªº"³æ¤@EXCEL.XLSÀɮסA´N¯à¦w¸Ë»P¸Ñ°£¦w¸Ëªº¼W¯q¶°"
¦]¬°§Ú·Q§â¼g¤@¨ÇVBA¤u¨ãÅý¨ä¥L¦P¨Æ¨Ï¥Î¡A
¤§«e³£¬Oª½±µcopy excel file¥h¨Ï¥Î¡A¦ý¬O¨ì³Ì«á­þ­Óexcel VBA¬O³Ì·sªºª©¥»¡A§Ú¦Û¤v³£§Ñ¤F¡C
§âVBA¶°¤¤¦¨¤@­ÓÀɮשñ¦bºô¸ô¼Ñ¤W¡A
¤è«K§Ú«áÄòmaintain¡C

ı±o³o­Óºô¯¸¤£¿ù¡A­È±oªá®É¶¡§ë¤J¡A
©Ò¥H§V¤O¤É¯Å¤¤ªü!

TOP

¦^´_ 9# HUNGCHILIN

HUNGCHILIN ¤j¤j¡A

§Ú§â§Aµ¹ªºexcel¤¤ªºVBA¡Acopy¨ì·sªºÀɮסA¨Ã§ï¬ÛÃöªºÀɮצWºÙ¡A
«oµLªk¦Û°Ê¥X²{¤u¨ã¦C¤Wªº«ö¶s¡A¤£ª¾¹D§Ú¦³º|±¼¤°»ò¦a¤è¡A
³Â·Ð§A¦AÀ°§Ú¬Ý¤@¤U¡AÁÂÁ¡C
test_addin.rar (6.62 KB)

BR,
Jarod

TOP

¦^´_ 13# HUNGCHILIN

·PÁ HUNGCHILIN ¤j¤j¹Ï¤å¨Ã­Zªº¸Ô²Ó¸Ñ»¡¡A
¬Ý°_¨Ó¬O¤p§Ì¹ïexcel°ò¥»ªº¾Þ§@¤£¬O¼ô¡A
·Pı¤W¹ïexcel file ¹ï excel application ªº³]©w¡A
°£¤FVBA¤§¥~ÁÙ¦³¨ä¥L¤è¦¡Àx¦s¡C

¦]¬°¦³ excel ¦³VBA¡AÅý¤p§Ì¶}©l³ßÅw¥Î excel¡C
¥i¥H¥Î¤£±M·~ªº tool §@±M·~ªº¨Æ¡C

BR,
Jarod

TOP

¦^´_ 17# jarodz

HUNGCHILIN ¤j¤j

test_addin ¦pªG¤£§â workbook ¤¤ªº isAddIn Äݩʳ]¬° true ªº¸Ü,
«ö¤u¨ã¶s·|§â¸ÓÀɮ׶}°_¨Ó,¦³¨S¦³¤èªk¤£­n§â¸ÓÀɮ׶}°_¨Ó?

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD