Vba runtime error 1004

[drluke]

I am copying a worksheet in one workbook to another with this macro:

Sub MoveSheets()
Workbooks.Open Filename:="Combined.xlsm"
Workbooks("Combined.xlsm").Sheets("NewData").Copy After:=Workbooks("Management Fees 2018.xlsm").Sheets("Inputs")
Workbooks("Combined.xlsm").Close savechanges:=False
End Sub

When attempting to run it now I get a runtime error that the workbook Combined cannot be found. The workbook exists, is open and is in the same folder as my target workbook.

Earlier when I tested it everything worked perfectly. Now that I've switched to my Mac version of Excel it doesn't.

Any ideas?

 

[mrshl9898]

Does this work?

Sub MoveSheets()
Workbooks.Open Filename:=ThisWorkbook.Path & "\" & "Combined.xlsm"
Workbooks("Combined.xlsm").Sheets("NewData").Copy After:=Workbooks("Management Fees 2018.xlsm").Sheets("Inputs")
Workbooks("Combined.xlsm").Close savechanges:=False
End Sub

 

[drluke]

Yes it does! Amazing - thank you so much!