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

(¤w¸Ñ¨M)vba¥i¥H¤£­n«ü©wÀɮצWºÙ¶Ü?

(¤w¸Ñ¨M)vba¥i¥H¤£­n«ü©wÀɮצWºÙ¶Ü?

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:08 ½s¿è

Application.Run "'¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î9906.xls'!²Ö­pªº¤½¦¡_°^Ämª÷ÃB"

   ¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î9906.xls³o­ÓÀɮ׬O°õ¦æªºÀÉ®×(runªº´N¬OÀÉ®×¥»¨­ªºµ{§Ç)
   ³o¦UÀɮתº¦WºÙ¨C­Ó¤ë³£·|ÅÜ¡A¦³¤°»ò¼gªk¥i¥H¤£­n¨C¦¸³£¥h§ï³o¥yµ{¦¡½X¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

Application.Run "'¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î9906.xls'!²Ö­pªº¤½¦¡_°^Ämª÷ÃB"

   ¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î9906.xl ...
freeffly µoªí©ó 2010-7-14 20:28


°²¦p¤é´Á¼Æ­È©ñ¦b "A1" ªº®æ
        Application.Run "'¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î" & Range("A1") & ".xls'!²Ö­pªº¤½¦¡_°^Ämª÷ÃB"

¦pªGa1 ªº¬O 9902, ¹B¦æ®É¤W¤@¥yªº¤å¦r·|Åܦ¨:
        Application.Run "'¹ê»Ú»P¹wºâ¤ñ-·~°È¥Î9902.xls'!²Ö­pªº¤½¦¡_°^Ämª÷ÃB"
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

ÁÙ¦³³oºØ¥Îªk³á
¤£¹L§Ú­ì¥»¬O·Q»¡¯à¤£¯à¥HACTIVEªº¤è¦¡°õ¦æ
¹³°õ¦æ¤¤ªº¤u§@ªí´N¬OActivesheets
°õ¦æ¤¤ªºÀɮפ£ª¾¹D¯à¤£¯à³oºØ¼gªk?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ victorl ©ó 2010-7-14 22:52 ½s¿è

¦^´_ 1# freeffly


    ¬JµM¬O°õ¦æ¤¤ªºÀɮסA¸Õ¸Õ¬Ý¥Î "ActiveWorkbook.Name" ¨ú­È
Application.Run (ActiveWorkbook.Name & "!²Ö­pªº¤½¦¡_°^Ämª÷ÃB")
¥t¥~¡A¨Ã«D½Õ¥Î¨ä¥LÀɮתº¥¨¶° or ¨ç¼Æ¡Aª½±µ©I¥s´N¥i¥H¤F§a¡AÀ³¸Ó¤£»Ý­n¨Ï¥Î¨ì Application.run §a

TOP

ÁÂÁÂvictorl ¤j¤j
¦]¬°§Úªºµ{«×¥Ø«e¥u¦b­×§ï¿ý»s¦nªº¥¨¶°
«Ü¦h¤j¤j©Ò¿×ªº°ò¥»¥\ÁÙ¤£¤Ó·|
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD