Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default fixed save as name?

Is there anyway I can force an excel file to change to a
predetermined name upon closure?

SDC
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default fixed save as name?

Possibly use the workbook_Beforeclose event. Save the workbook in that
routine.

Look at Chip Pearson's site on events if you are not familiar with
programming events.
http://www.cpearson.com/excel/events.htm



--
Regards,
Tom Ogilvy

scrabtree23 wrote in message
...
Is there anyway I can force an excel file to change to a
predetermined name upon closure?

SDC



Reply
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 do I save a 689 character fixed field/record format file Mike Excel Discussion (Misc queries) 1 July 23rd 08 12:22 AM
Save Excel file with certain columns with fixed width Vijay Kotian Excel Discussion (Misc queries) 3 March 13th 07 01:48 PM
how do i save an excel file as a non-delimited, non-packed fixed jthisdell Excel Discussion (Misc queries) 1 August 29th 06 01:27 PM
save an excel file in fixed length records whose fields are blank ascii save Excel Discussion (Misc queries) 1 October 13th 05 06:01 PM
Save data in a worksheet in fixed length fields... dietzd Excel Discussion (Misc queries) 1 January 26th 05 06:17 PM


All times are GMT +1. The time now is 07:20 PM.

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"