Including Invoice # in Filename

[cords]

Hello - Thanks for your assistance with my previous excel issues. Here's a new issue. I have an automated macro that increments a cell by one every time the file is opened; this value is my invoice number. See cell D3 in the attached file. I'd like to know how to incorporate this (invoice) number as part of the file name when the file is saved. Obviously, I'd like a new file each time the file is saved, and not to overwrite the previous file. I have attached the file with the embedded macro. Many thanks for your assistance!!!!

[JasperD]

Assuming you're saving into c:\test (change this as applicable), use the code below in the workbook code area.
It will save your workbook when the user wants to save or when the user closes the workbook as ""New Template - Rev - " and the value in D3.

Please Login or Register  to view this content.

Please click the * below if this helps

[cords]

Yes, the above worked and many thanks!!! Sorry, need to refine the issue slightly. Instead of defining the directory explicitly, as done above, would it be possible to update the above code, or any code meeting the above filename requirements, including saving the file in current directory that the file is in? I don't want to explicitly define any particular directory; I want the file to be saved in the current directory, and the directory will continuously change. The file will be copied into the appropriate directories manually, as needed.

[cords]

Please add the following functionality: 1) When the 'x' is selected, a pop-up to be dispalyed indicating if the file should be saved with 'Yes', 'No', & 'Cancel' options. 2) When 'Save As' is selected, the filename can be modified as per the 'normal' rules.

Thanks again for your time.

[JasperD]

Sure, change "C:\test\" in the code to ".\"

Yes, the above worked and many thanks!!! Sorry, need to refine the issue slightly. Instead of defining the directory explicitly, as done above, would it be possible to update the above code, or any code meeting the above filename requirements, including saving the file in current directory that the file is in? I don't want to explicitly define any particular directory; I want the file to be saved in the current directory, and the directory will continuously change. The file will be copied into the appropriate directories manually, as needed.