Rename Workbook prior to saving

[rkjudy]

I have a need to simply rename a workbook without saving. I have a master template named "IR QT" but, within the workbook, I run a macro that saves the file with content from a cell as the filename. After the 'Save' macro is executed, the sheet stays open, as planned, but obviously the file has been renamed. What I would like to happen at the end of the 'Save' macro is for the sheet to be renamed (not re-saved) to "IR QT". I just need the VBA code to put at the end of the 'Save' macro to do the rename back to "IR QT". Any suggestions?

[shg]

Post the code you have.

[rkjudy]

Here's my code. I know it may not be perfect, but it works fine. Thanks again for looking.

Please Login or Register  to view this content.

[foxguy]

ThisWorkbook.SaveCopyAs sFileName instead of SaveAs