Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Workbook Name without Save As?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Workbook Name without Save As?
Don,
A workbook's name is the same as its file name, so you can't change the name without doing a Save. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Don Wiss" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Workbook Name without Save As?
You could modify this to suit
Sub movefile() OldName = "C:\yourfolder\1065.xls" NewName = "C:\a\1065.xls" Name OldName As NewName End Sub "Don Wiss" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Changing Save As Type in Save as dialog box | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |