saving workbook asking to rename file every time I save

  • Thread starter Thread starter francie
  • Start date Start date
F

francie

I want to save an excel document after a modification, it
will rename the file by adding 1 each
time I save the document.

Thank you!

francie
 
Hi
is VBA a feasible solution for you? You could use the
Workbook_BeforeSave event and increment the number.

Note: these kind of solution won't work if macros are disabled. So
please post back if this is an option for you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save and rename 6
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
How to rename workbook that I am editing without saving? 1
How can we convert OST to PDF file format? 1
Word refuses to save a document 4
Saving Workbook 1
Excel workbook will not save 2
How to make a .XLTM template file default to save as .XLSM type? 1

Back
Top