Overwriting existing files

's Computer Specifications

How can I overwrite an existing file with the same name with the procedure
SaveAs in Visual Basic for Applications without the program asking me for
overwriting ("Yes, No, Annuleren").

Thanks

Luc

's Computer Specifications

Luc,

Application.DisplayAlerts = False
.... your saveas code
Application.DisplayAlerts = True

hth,

Doug

"Luc Martens" <(E-Mail Removed)> wrote in message
news:MASZi.202797$(E-Mail Removed)...
> How can I overwrite an existing file with the same name with the procedure
> SaveAs in Visual Basic for Applications without the program asking me for
> overwriting ("Yes, No, Annuleren").
>
> Thanks
>
> Luc
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Overwriting existing files	=?Utf-8?B?SmVhbm5l?=	Windows Vista General Discussion	24	27th Sep 2007 01:06 AM
Word Templates: .dot overwriting vs. .dotm overwriting	=?Utf-8?B?ZG1pbnNvbg==?=	Microsoft Word Document Management	0	23rd Jul 2007 07:56 PM
Move files and prompt user if overwriting existing file	Mike	Microsoft Access	2	23rd May 2007 05:11 AM
exporting - overwriting existing snp. files	=?Utf-8?B?c21hZ2FsYTI5?=	Microsoft Access Reports	2	22nd Nov 2005 04:27 PM
Avoid IE OverWriting Existing Sites Already Loaded?	clintonG	Windows XP Internet Explorer	3	16th Nov 2004 12:03 AM