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

[µo°Ý] ¦p¦ó´À´«Excel-UserForm or Module?

[µo°Ý] ¦p¦ó´À´«Excel-UserForm or Module?

¥»©«³Ì«á¥Ñ saqadk ©ó 2011-10-15 15:58 ½s¿è

Hi ¦U¦ì¦n,
°²³]§ÚªºUserFrom or Module¬O©ñ¦bServer¦@¥Î¸ê®Æ§¨¡A¦p¦óÅýUser³z¹LVBAªº¤è¦¡©Î¨ä¥LAPI¤è¦¡´À´«©O?
Thanks,

¦^´_ 1# saqadk
¦p¦óÅýUser³z¹LVBAªº¤è¦¡©Î¨ä¥LAPI¤è¦¡¸m´«©O?
½Ð»¡©ú ¸m´«¬O¦ó·N«ä?

TOP

¥»©«³Ì«á¥Ñ saqadk ©ó 2011-10-15 16:02 ½s¿è

¦^´_ 2# GBKEE
Hi GBkee,
A¹q¸£¡A±NaÀɮ׼ҲթΦ۩wªí³æ¶×¥X¦Ü¦@¥Î¸ê®Æ§¨¡AB¹q¸£±NaÀɮ׳z¹LVBA©ÎAPI±N¦P¦WºÙªº¼Ò²Õ©Î¦Û©wªí³æ±q¦@¥Î¸ê®Æ§¨¨ú±o¤U¨Ó¡A¨Ã§@´À´«.
©Î¬OB¹q¸£¥´¶}aÀɮקY¥i¸ü¤J¯S©w¼Ò²Õ©Î¦Û©wªí³æ¡C
Thanks.

TOP

¼Ò²Õ©Î¦Û©wªí³æ¥»´N¸òµÛ¤u§@ï¶]
¥ô¦ó¹q¸£¥´¶}³£·|¸ü¤J¡A°£«D¦w¸Ëoffice®É¿ï³Ì¤p¦w¸Ë¡A¨S¦³³o¨Ç¥\¯à¡C

TOP

¦^´_ 3# saqadk
B¹q¸£±NaÀɮ׳z¹LVBA©ÎAPI±N¦P¦WºÙªº¼Ò²Õ©Î¦Û©wªí³æ±q¦@¥Î¸ê®Æ§¨¨ú±o¤U¨Ó
B¹q¸£ : Workbooks("B¹q¸£").VBProject.VBComponents.Import ("d:\¦@¥Î¸ê®Æ§¨\¼Ò²Õ.bas")
Import->¶×¤J

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD