| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically saving a file
Hi, I wish to save a file which opens with a macro without the "do you wish
to replace this file" prompt appearing. File is an update of the scheduled excel spreadsheet from an oracle database. Thanks and regards, Davie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically saving a file
Try this:
Application.DisplayAlerts = False ActiveWorkbook.Save Application.DisplayAlerts = True "davethewelder" wrote: Hi, I wish to save a file which opens with a macro without the "do you wish to replace this file" prompt appearing. File is an update of the scheduled excel spreadsheet from an oracle database. Thanks and regards, Davie |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically saving a file
Mike, worked a treat. Many Thanks
Davie "Mike" wrote: Try this: Application.DisplayAlerts = False ActiveWorkbook.Save Application.DisplayAlerts = True "davethewelder" wrote: Hi, I wish to save a file which opens with a macro without the "do you wish to replace this file" prompt appearing. File is an update of the scheduled excel spreadsheet from an oracle database. Thanks and regards, Davie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a file automatically everytime it is closed | Excel Discussion (Misc queries) | |||
| File/Close automatically saving changes without prompt | Excel Discussion (Misc queries) | |||
| Automatically ZIP Excel File on saving... | Excel Programming | |||
| automatically saving a file every 5 minutes | Excel Programming | |||
| Saving File automatically | Excel Programming | |||
Linear Mode
