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?
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?