| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program Auto Yes for overwriting files
I have a save dialog in one of my macros but since it is overwriting file in a location week after week I get a popup that says A file named "D6_Panic.xls" already exists in this location. Do yo want to replace it? Is there a way to automatically program a yes there in the macro -- DK ----------------------------------------------------------------------- DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451 View this thread: http://www.excelforum.com/showthread.php?threadid=54254 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Auto Yes for overwriting files
before save use this line of code:
application.displayalerts = false after saving turn it back on with this line of code application.displayalerts = true HTH Die_Another_Day |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Auto Yes for overwriting files
It works, thanks!!! Does that work for Deleting Sheets too? Sometime when I delete a sheet it asks if I'm sure -- DK ----------------------------------------------------------------------- DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451 View this thread: http://www.excelforum.com/showthread.php?threadid=54254 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Program Auto Yes for overwriting files
Yes.
-- Regards, Tom Ogilvy "DKY" wrote in message ... It works, thanks!!! Does that work for Deleting Sheets too? Sometimes when I delete a sheet it asks if I'm sure. -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=542542 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XLS Files Default Program | Excel Discussion (Misc queries) | |||
| What program should i use for archived files? | Excel Discussion (Misc queries) | |||
| Convert files from one program to another | Excel Programming | |||
| Automatically overwriting files | Excel Programming | |||
| Program Files Folder | Excel Programming | |||
![DKY[_114_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
