hi all I'm having this problem with the below vba code
Public Sub CopySheetFromClosedWorkbook()
Dim sourceBook As Workbook
Application.ScreenUpdating = False
Set sourceBook = Workbooks.Open("C:\Users\jack\Documents\abcd\Sales invoice.xlsx")
With Workbooks(sourceBook.Name)
.Sheets("aaa").Copy After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count)
sourceBook.Close
Application.ScreenUpdating = True
end with
End Sub
I'm getting error "copy method of worksheet class failed"
its possible that its trying to copy it to personal.xlsb but imnot sure
any help is apricated
thanks
Bookmarks