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

½Ð±Ð§ó·s³æ¤@Àx¦s®æ³sµ²ªº»yªk ??

½Ð±Ð§ó·s³æ¤@Àx¦s®æ³sµ²ªº»yªk ??

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-7-31 11:39 ½s¿è

½Ð±Ð§ó·s³æ¤@Àx¦s®æ³sµ²ªº»yªk ??
='C:\xls3\[sheet1.xls]good'!$S$2

½Ð±Ð§ó·s³æ¤@Àx¦s®æ³sµ²ªº»yªk ??
='C:\xls3\[sheet1.xls]good'!$S$2
t8899 µoªí©ó 2014-7-31 11:35


?
§A¬O­n©³¤U³o­Ó¶Ü?
Range("A1").Formula = "='C:\xls3\[sheet1.xls]good'!$S$2"

TOP

?
§A¬O­n©³¤U³o­Ó¶Ü?
Range("A1").Formula = "='C:\xls3\[sheet1.xls]good'!$S$2"
luhpro µoªí©ó 2014-8-3 09:47


¤£¬O¡A¬OUpdateLinks

TOP

¦^´_ 3# t8899

½Ð°Ý¬O«ü³o­Ó¶Ü?
   

ActiveWorkbook.UpdateLink Name:="C:\xls3\[sheet1.xls]good'!$S$2", Type:=xlExcel
¾Ç²ßVBA

TOP

¦^´_  t8899

½Ð°Ý¬O«ü³o­Ó¶Ü?

ActiveWorkbook.UpdateLink Name:="C:\xls3\[sheet1.xls]good'! ...
s90068 µoªí©ó 2014-8-4 19:00

¬Oªº
³o¨â­Ó¦³¦ó¤£¦P,·N¸q¬°¦ó?
Type:=xlExcel
Type:=xlExcelLinks

TOP

¦^´_ 5# t8899


   :L ¤£¦n·N«äÀ³¸Ó¬O   Type:=xlExcelLinks  ¡A¤Ö¶K Links
¾Ç²ßVBA

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD