Changing Workbook Name without Save As?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

I have a macro that loads up a read only workbook and populates it with
data. It now leaves it up to the user to do a save as. I'd like to change
the workbook name to one assembled from the user's data, but not actually
save it. The user needs to input more data first. Logically it would be:

ActiveWorkbook.Name = "NewName.xls"

But this doesn't work. Is doing this possible?

Thanks, Don <donwiss at panix.com>.
 
You'll get better guidance from an Excel group, but here's what I found in Excel help, under programming information, for the workbook object:

"The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name. "

Keith
 
Back
Top