saving excel sheets

S

SenorPr0n

Member
Joined
Sep 5, 2003
Messages
12
Location
New Jersey, USA
I have a program that creates excel sheets and saves them, but I dont want it to prompt the user if the file already exists. Is there a way I can get it to automatically overwrite the existing file?
 
Set the DisplayAlerts property equal to False before saving the file.
Then reset it back to True.

BTW DisplayAlerts is a property of the Application Object
 
Back
Top