Ok, so the invoice.xlsm file works fine, I have some "dummy" client names on the clientnames sheet, when I click on the "Save Invoice" it saves it in a folder. Now the problem starts when I copy the (real) data from client list.xlsx file into the invoice.xlsm file (in the clientnames sheet). I get the "The file could not be accessed. Try one of the following: -Make sure the specified folder exists...." error. I have no idea what is wrong.
Invoice.xlsmclient list.xlsx