Question

excel运行时错误'9'下标越界

Sub test1()
Application.ScreenUpdating = False
Workbooks.Open "C:\Users\腾\Desktop\test.xlsx"
'读取或写入数据的代码
Workbooks("C:\Users\腾\Desktop\test.xlsx").Close SaveChanges:=True
Application.ScreenUpdating = True
End Sub

Answer 1

C:\Users\腾\Desktop\test.xlsx 这个文件名是否修改过或位置变动了，不在所指向的文件夹下？

Answer 2

"C:\Users\腾\Desktop\test.xlsx"文件是否在存在