i have 2 files
Main.xlsm
Database.xlsx
What i want to do its on Main workbook open, open Database.xlsx and copy it to a sheet in Main called "exceptions" and then close Database.xlsx
Im currently opening Database with:
Workbooks.Open (ActiveWorkbook.Path & "\Database.xlsx")
As its in the same...