æALT+F11,æå
¥ä¸ä¸ªæ¨¡å,è¾å
¥ä¸å代ç .å³å¯
Sub copyAll()
fname = "C:\Book2.xls" 'éè¦å¤å¶çexcelæ件å°ååæ件å,ä½ èªå·±ä¿®æ¹
Set d = GetObject(fname) 'æå¼æ件
d.sheets("sheet1").Cells.Copy ActiveSheet.Cells(1, 1) 'å°sheet1å®å
¨å¤å¶å°å½å表
d.Close 'å
³éæ件
Set d = Nothing
End Sub
温馨提示:答案为网友推荐,仅供参考