急寻excel的VB高手,请问我想把excel A的sheet2里的内容导入到excel B的sheet1里,怎么来编这个宏?

日期:2011-02-26 21:54:24 人气:1

急寻excel的VB高手,请问我想把excel A的sheet2里的内容导入到excel B的sheet1里,怎么来编这个宏?

Dim Wb As Workbook Dim Temp As String Application.ScreenUpdating = False Temp = "D:" & "\1.xls" '这个是你要导入的表文件路径 Set Wb = GetObject(Temp) With Wb.Sheets("sheet2"
    A+
热门评论