急寻excel的VB高手,请问我想把excel A的sheet2里的内容导入到excel B的sheet1里,怎么来编这个宏?
急寻excel的VB高手,请问我想把excel A的sheet2里的内容导入到excel B的sheet1里,怎么来编这个宏?
日期:2011-02-26 21:54:24 人气:1
Dim Wb As Workbook
Dim Temp As String
Application.ScreenUpdating = False
Temp = "D:" & "\1.xls" '这个是你要导入的表文件路径
Set Wb = GetObject(Temp)
With Wb.Sheets("sheet2"