| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Force Save over existing file
I have a macro that i have made that saves to a temp file. I want to set the macro to automatically save to this file regardless if the file already exists. I have had a play with it and search on here and couldnt find the anser. Can someone please help. Ty -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=545355 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force Save over existing file
Hi XCESIV,
Try: Application.DisplayAlerts = False 'Your save code Application.DisplayAlerts = True --- Regards, Norman "XCESIV" wrote in message ... I have a macro that i have made that saves to a temp file. I want to set the macro to automatically save to this file regardless if the file already exists. I have had a play with it and search on here and couldnt find the anser. Can someone please help. Ty -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=545355 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force Save over existing file
hi.
add this to your macro before the save as command... Application.DisplayAlerts = False then be sure to turn alerts back on after the save as. Application.DisplayAlerts = True regards. FSt1 "XCESIV" wrote: I have a macro that i have made that saves to a temp file. I want to set the macro to automatically save to this file regardless if the file already exists. I have had a play with it and search on here and couldnt find the anser. Can someone please help. Ty -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=545355 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Force Save over existing file
You can also use
Application.AlertBeforeOverwriting = False Which leaves other alerts on -- Tony Green "XCESIV" wrote: I have a macro that i have made that saves to a temp file. I want to set the macro to automatically save to this file regardless if the file already exists. I have had a play with it and search on here and couldnt find the anser. Can someone please help. Ty -- XCESIV ------------------------------------------------------------------------ XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271 View this thread: http://www.excelforum.com/showthread...hreadid=545355 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Existing file not defaulting to same location using "Save As" | Excel Discussion (Misc queries) | |||
| can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
| Automatically Replacing existing file on save | Excel Programming | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
| Automatically replace existing file on save | Excel Programming | |||
![XCESIV[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
