Save as cell contents & date on close

Hello! Sorry if this has been posted before but I can't find an answer.

Okay so I want a macro to save as a workbook when you close it with the filename of cell contents (B4) and today's date. Also I am pretty much completely new to VBA so I don't even know where to start. I know how to get into the editor that's about it .

Thanks

Do you mean save a copy of the workbook and discard the changes in the original?

What sheet is the B4 on that you want as part of the file name?

What does B4 contain? Text? Number? Special characters?

BSB

Yes, sorry I wasn't more clear. I want to save the file as a new file and discard any changes from the original. It's just on sheet 1? And it consists of a concatenate formula from several different cells on the sheet, text and numbers.

Thanks

Sorry for the delay. Got distracted by something edible!

Have a look at the attached. You'll have to amend the code slightly to take account of your desired save location.
To do this:

1. Open the workbook
2. Press Alt+F11 (to open the VB Editor)
3. Double click where it says "ThisWorkbook" (shoudl be near the top left corner of the VBE)
4. Amend the line with "G:\My Documents\" to your desired path
5. Close the VBE
6. Exit the file

Is that any use to you?

BSB

Yes! This worked. Thank you very much. Sorry I should have mentioned this at the start but is there a way for me to save the new file as non-macro enabled document? I tried changing the file type to .xlsx but got an error.

Thanks

Try this version.

BSB

Thanks!