Thread: [Solved] Rename Document & Save
View Single Post
 
Old 05-16-2013, 09:48 AM
d4okeefe d4okeefe is offline Windows Vista Office 2010 64bit
Advanced Beginner
 
Join Date: Apr 2013
Posts: 77
d4okeefe is on a distinguished road
Default Rename Document & Save

I would like to create a macro that renames an open document, and saves the newly named document to the same folder as the open document.

For example, the file I have open is located in H:\, and the file name is 00000 Frame aa 0.docx. After running the macro, the new file name should be: 00000 Frame aa 01.docx

Or, the open document's file name is 12345 de Ville cv 01.docx, and the new file name should be 12345 de Ville cv 02.docx.

In essence, the new file name should be very similar to the open document's, except that the number before .docx should be one higher.

To add a wrinkle, I would also like the macro to display a warning if the new document name is already in the folder.

Thanks!

Daniel
Reply With Quote