Renaming an open workbook
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.
|