Automatically saving a file

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically ZIP Excel File on saving...	Darin Kramer	Microsoft Excel Programming	2	3rd Feb 2007 01:57 AM
automatically saving a file every 5 minutes	George Ferreira	Microsoft Excel Programming	0	16th Nov 2006 02:52 AM
Automatically saving an website file	=?Utf-8?B?U3R1Sm9s?=	Microsoft Access External Data	1	2nd Mar 2006 10:30 PM
Saving File automatically	dok112	Microsoft Excel Programming	2	24th Jun 2004 08:34 PM
Saving Sent messages to Sent File Automatically	Alex C	Microsoft Outlook Discussion	0	12th Jan 2004 03:05 AM