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

Formula°ÝÃD

Formula°ÝÃD

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-8-10 17:42 ½s¿è

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

¦]¬°¤°»ò³o­Ó¤£¯àRUN??
VBA
  1. MYD = 201003
  2. MYD2 = 2001001



  3.     Range("A1").Formula "='Z:\Site Diary\daily report " & MYD & "\[" & MYD2 & ".xls]Page1'!$Q$17"
½Æ»s¥N½X

PPP.JPG (67.39 KB)

PPP.JPG

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

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

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-8-11 19:26 ½s¿è

¦^´_ 2# GBKEE


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

TOP

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

TOP

¦^´_ 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><
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 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¦ó¨Ï¥Îªº

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-8-13 16:57 ½s¿è

¦^´_ 6# GBKEE

§Úª¾¨ì¤°»ò¨Æ¤F><       /«e¦h¤F­ÓªÅ®æ.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD