Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default turn off the " replace file?" question when saving excel files

I want to be able to over write a lot of existing Excel files but do not want
to be asked if I want to overwrite the existing file each time
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default turn off the " replace file?" question when saving excel files

Hi
application.displayalerts=false
'save file
application.displayalerts=true

--
Regards
Frank Kabel
Frankfurt, Germany
"Dave Parkes" <Dave schrieb im Newsbeitrag
...
I want to be able to over write a lot of existing Excel files but do not
want
to be asked if I want to overwrite the existing file each time



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
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" chrispal86 Excel Discussion (Misc queries) 2 February 2nd 10 08:36 PM
How do I turn off "Initializing Folders" every time I open a file. BIOYA_2000[_2_] Excel Discussion (Misc queries) 1 May 9th 09 05:56 AM
How do I replace decimals starting with "." to "0." in excel? Julio Excel Discussion (Misc queries) 2 November 1st 08 07:48 AM
Saving Excel "read only" files to RW-CD docroc6 Excel Discussion (Misc queries) 0 March 29th 07 01:42 AM
How do I keep an excel file from saving to "COPY OF" file name Sandy Excel Discussion (Misc queries) 1 July 5th 06 06:51 PM


All times are GMT +1. The time now is 10:46 PM.

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

About Us

"It's about Microsoft Excel"