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: 683
Default Rename workbook upon closing

Hi,
Can I have my workbook renamed upon closing and make the name the date which
is found in cell al of sheet named "patrol log". Two twists to this request
is that (1) I want to make the name consist of a constant "Patrol Log" with
the date from the a1 cell following, ex: Patrol Log 10-18-04. (2). I do not
want to have a save as request performed because that ends up keeping the
original workbook around, I want a rename request performed so that the
original is not saved.

I hope someone can help
Thank You,
Brian

 
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
How to open a new workbook and rename the workbook? pokdbz Excel Discussion (Misc queries) 3 December 26th 07 03:37 PM
rename a group of spreadsheets in a workbook bob Excel Discussion (Misc queries) 1 October 2nd 07 05:21 PM
Rename a workbook! aiyer[_22_] Excel Programming 1 May 12th 04 05:12 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
Workbook, worksheet rename PW[_2_] Excel Programming 0 September 4th 03 12:34 PM


All times are GMT +1. The time now is 02:52 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"