|
下列从外部工作簿导入数据的代码,在部分电脑运行正常,在个别电脑运行出现:运行时错误‘1004’:类Worksheet方法无效
请问是不是Microsoft Office缺少什么?卸载重装Office也不行!
求各位大哥大姐小弟小妹帮看看是什么原因?谢谢!
Sub 导入()
Dim sht As Workbook, rng As Range, wjm
Sheets("封面").Select
wjm = [M10]
Set sht = Application.Workbooks.Open(wjm) '运行时错误‘1004’:类Worksheet方法无效
Set rng = sht.Sheets("收入总表").Range("C5:I450")
rng.Copy
ThisWorkbook.Sheets("收入总表").Range("AE5").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
sht.Close False
Set rng = Nothing
Set sht = Nothing
End Sub
|
|