LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
renaming a workbook serge T Excel Programming 6 October 22nd 07 09:57 AM
Renaming a workbook without saving Matt Excel Programming 3 May 22nd 06 11:07 AM
Workbook renaming billyb Excel Programming 3 May 31st 04 04:05 PM
Workbook renaming! aiyer[_21_] Excel Programming 1 May 12th 04 08:03 PM
Renaming workbook! aiyer[_20_] Excel Programming 1 May 11th 04 11:34 PM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"