Formula°ÝÃD

basarasy

A1  ='Z:\Site Diary\daily report 201003\[201001.xls]Page1'!$Q$17

¦]¬°¤°»ò³o­Ó¤£¯àRUN??
VBA

1. MYD = 201003
   
2. MYD2 = 2001001
   
3. 
   
4. 
   
5. 
   
6.     Range("A1").Formula "='Z:\Site Diary\daily report " & MYD & "\[" & MYD2 & ".xls]Page1'!$Q$17"

½Æ»s¥N½X

GBKEE

¦^´_ 1# basarasy
Range("A1").Formula = "='Z:\Site Diary\daily report " & MYD & " \[" & MYD2 & ".xls]Page1'!$Q$17"

basarasy

¦^´_ 2# GBKEE


    ÁÂÁÂGBKEE¤j¤j.
¦ýÁÙ¦³1­Ó°ÝÃD¬O,runªº®É¶¡·|¼u¥X1­Ó¶}¤å¥óªºªF¦è­n§Ú¶}¹ïÀ³ªº¤å¥ó,¤£¶}´N¤£¯à¥X¼Æ.¦³¤°»ò¤èªk¥i¥H¤£¼u¥X¤å¥ó¤S¯à¥X¼Æ¶Ü?

GBKEE

¦^´_ 3# basarasy
³oÀ³¸Ó¬O°Ñ·Ó¨ìªºÀɮצWºÙ©Î¸ê®Æ§¨¦³¿ù»~§a
Àˬd¬Ý¬Ý ÀɮצWºÙ¤Î¸ê®Æ§¨ ¬O§_¥¿½T ¥B¦s¦b

basarasy

¦^´_ 4# GBKEE
ÀɮצWºÙ¤Î¸ê®Æ§¨ ¥¿½T ¦s¦b
¦pªG¦bA1¥´³o­Ó´N¨S¦³°ÝÃD 'Z:\Site Diary\daily report 201003\[201001.xls]Page1'!$Q$17
¤@¥Îvba´N¦³°ÝÃD><

GBKEE

¦^´_ 5# basarasy
¦pªG¦bA1¥´³o­Ó´N¨S¦³°ÝÃD   ='Z:\Site Diary\daily report 201003\[201001.xls]Page1'!$Q$17
¤@¥Îvba´N¦³°ÝÃD><
½Ð°Ý§A ¦p¦ó¨Ï¥Îªº

basarasy

¦^´_ 6# GBKEE

§Úª¾¨ì¤°»ò¨Æ¤F><       /«e¦h¤F­ÓªÅ®æ.