Renaming a workbook in VBA
Activeworkbook.SaveAs "filename and path"
If the file already exists by this name, then use
Application.Displayalerts = False
to eliminate the replacement warning messages. Set back to True when done.
Productivity add-ins and downloadable books on VB macros for Excel
> Is it possible to rename the active workbook before saving it? I mean the
> add-in changes the default name of the workbook? I've been trying to do
> that using VBA, but I get the message that the name property is read-only.
> A. Jay