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

CALL¥t¤@­ÓÀɮתºMACRO

CALL¥t¤@­ÓÀɮתºMACRO

¥»¤H«Ü±`­n¥Ñ¨t²Î¤ºEXPORT¤@°ïRAW¸ê®Æ¨Ï¥Î, ¦ÓEXPORT¥X¨Óªº¸ê®Æ¨ä¹ê¨C¤§³£¥u¬O­n¨ä¤¤´X­ÓCOLUMN

¥»¤Hª¾¹D¥i¥H¦p¦ó²³æ¦a¥ÎMACRO¥h³B²z¦P¤@¶µ¤u§@, ¦ý¸ê®Æ¬O¨C¦¸EXPORT¥X¨Óªº, ¦p¨C¦¸³£­n¥[MACROªº½X¤JÀɮפ¤¤S¦n¦ü¤£°÷®Ä²v

½Ð°Ý¥i¥H¦³¤èªk¥i¥HMACRO¼g¦b¤@­ÓÀɮ׫á, ¥[¤J¤@­ÓBUTTON ©óEXCEL, ¤§«á¨C¦¸¶}EXPORT¥X¨Óªº¸ê®Æ¥u­nCLICK¤@¤U´N·|CALL ¨º­ÓMACRO

¥i¥H°µ¨ì¶Ü?

©Î¬OÁÙ¦³¤°»ò§ó¦nªº¨£Ä³, ÁÂÁÂ

¥»¤H«Ü±`­n¥Ñ¨t²Î¤ºEXPORT¤@°ïRAW¸ê®Æ¨Ï¥Î, ¦ÓEXPORT¥X¨Óªº¸ê®Æ¨ä¹ê¨C¤§³£¥u¬O­n¨ä¤¤´X­ÓCOLUMN

¥»¤Hª¾¹D ...
rc_chc µoªí©ó 2014-3-25 20:48


°Ñ·Ó Excel VBA ªº»¡©ú:
Run ¤èªk
¦¹½d¨ÒÅã¥Ü¦p¦ó©I¥s¥¨¶°¤u§@ªí Mycustom.xlm (¥²¶·¥ý¶}±Ò¦¹¥¨¶°¤u§@ªí) ¤¤©w¸qªº¨ç¼Æ¥¨¶° My_Func_Sum¡C¦¹¨ç¼Æ¨Ï¥Î¨â­Ó¼Æ­È¤Þ¼Æ (¦¹½d¨Ò¤¤¬° 1 ©M 5)¡C

mySum = Application.Run("MYCUSTOM.XLM!My_Func_Sum", 1, 5)
MsgBox "Macro result: " & mySum


¥t¦pªG§A¦³´X­ÓÀɮ׳£¥i¯à·|©I¥s¨ì¸Ó¥¨¶°ªº¸Ü,
¥i¥H¦Ò¼{§â¥¦§ï¦¨¼W¯q¶°, ¥i°Ñ¦Ò¥H¤Uªº°Q½×:

¦p¦ó±NVBAµ{¦¡Âন¼W¯q¶°?

¦Û­qApplicatoin¨Æ¥ó/ºÊ±±©Ò¦³¬¡­¶Ã¯/°µ¦¨¼W¯q¶°

TOP

ÁÂÁ¦^ÂÐ

·|°Ñ¦Ò¤@¤U¦p¦ó¥i¥H°µ¨ì

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD