Good afternoon everyone,
I had VBA macro's already on our invoice spreadsheet but I'm not sure what has happened or was updated, and now I get an error with the date formula. This is what was already drafted and worked well until this problem. I've checked numerous places online and I just don't know what to do to correct it. I basically need a new file saved with the invoice number and date each time the macro workbook is opened (ie: the below file name should be 453401062021 as a regular excel spreadsheet.) HELP please
I had VBA macro's already on our invoice spreadsheet but I'm not sure what has happened or was updated, and now I get an error with the date formula. This is what was already drafted and worked well until this problem. I've checked numerous places online and I just don't know what to do to correct it. I basically need a new file saved with the invoice number and date each time the macro workbook is opened (ie: the below file name should be 453401062021 as a regular excel spreadsheet.) HELP please