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

¸óÀɮקì¨úÄæ¦ìªº­È

¸óÀɮקì¨úÄæ¦ìªº­È

½Ð±Ð°ª¤â,§Ú¬Oµ{¦¡·s¤â,©Ò¥H°Ýªº°ÝÃD«Ü¥Õ·ö½Ð¨£½Ì{:3_61:} ,
§Ú·Q­n±q¤£¦PªºÀɮפ§¶¡,§ì¨ú¬Y­Ó­È©ñ¨ì¢ÏÀÉ®×,§Ú¦bAÀɼgVBA½Ð°ÝÀ³¸Ó¦p¦ó¼g©O?
¦b¤£¥´¶}¨Ó·½Àɪº±¡ªp¤U...{:3_55:}

Sub TEST()
Range("A1").Value = "='d:\downloads\[a.xls]Sheet1'!B1"
Range("A2").Value = "='d:\downloads\[b.xls]Sheet1'!B1"
Range("A3").Value = "='d:\downloads\[c.xls]Sheet1'!B1"
End Sub

¦^´_ 1# kolin2009

³o¼Ë¤£¬O´N¼g¤J¤½¦¡¤F¶Ü?
¦pªG¤£·Q¯d¤U¤½¦¡
¦h¤@¦æ
[A1:A3]=[A1:A3].Value
³o¼Ë´N¥u³Ñ¤U­È¡A¤£§t¤½¦¡

TOP

¦^´_ 2# white945

³o¼Ë¼g¨Ã¨S¦³¯d¤U¤½¦¡­C,¥i¥H°õ¦æ,¥i¬O¨C¦¸°õ¦æ³£·|¶]¥X¤T¦¸µøµ¡,¸ß°ÝA/B/C.XLSÀɪº¦ì¸m

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD