Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an application that generates some data and launches a workbook named
setup.xls and places the data on the sheet for the user to have a report. Once this has been done, I would like to rename the filled workbook with the name of of one the cell values, for example lets say that the value of "H5" is "333-2323A" I would like to rename the open work book as 333-2323A.xls I am trying to prevent the original copy of setup.xls from being over written everytime it gets ran. One other variation to this would be to have the vba and protection removed for the renamed open book since at this point it is just a data report and the vba is no longer needed. If anyone has any suggestions I am open... Thanks, Jeff W. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
renaming a workbook | Excel Programming | |||
Renaming a workbook without saving | Excel Programming | |||
Workbook renaming | Excel Programming | |||
Workbook renaming! | Excel Programming | |||
Renaming workbook! | Excel Programming |