Re: question about Excel object... (how to save but overwrite)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

thank you!
thats what i was looking for


"Brian McDermott" <No_SPambmcdfc@xxxxxxxxxxx> wrote in message
news:Otyc3guPGHA.5296@xxxxxxxxxxxxxxxxxxxxxxx
Presuming your Excel object is named objXL, insert the following line just
before you attempt to save the file. Set it back to true after the save
has occurred so any future alerts are picked up.

objXL.DisplayAlerts = FALSE

Brian McDermott
QA.com

"SixHouse" <NOSPAM_sixhouse@xxxxxxxxxxxxxxxx> wrote in message
news:OHaLTOrPGHA.128@xxxxxxxxxxxxxxxxxxxxxxx
i run a script that writes output to an excel spread***. im using the
saveAs method to save the spread*** when im done but if the file already
exists i get a prompt asking me if i want to overwrite. since i always
will want to overwrite, how can i save over the existing file without
being prompted.... there must be am argument or something i can pass to
the saveas method... no?

thanks!






.

Quantcast