我只是尝试将工作表 3 从打开的工作簿复制到关闭的工作簿,但出现运行时错误。我该怎么做?
Sub vba_copy_sheet()
Dim mybook As Workbook
Application.ScreenUpdating = False
Set mybook = _
Workbooks.Open _
("C:\Folder Path\Closed File.xlsx")
Sheets(3).Copy Before:=mybook.Sheets(1)
mybook.Close SaveChanges:=True
Application.ScreenUpdating = True
End Sub