Don't want to see "File already exists message"

[Aerowolf]

I have buttons set up to print out reports and at the same time output them to a snapshot on the local network. How do I set it up so that the box "File already exists, do you want to replace?" does not show up?

I've tried turning off the warnings but that doesn't help.
I'm using a macro that looks like this:

SetWarnings No
OpenReport
Output To
SetWarnings Yes

Thanks

Edwin

 

[smedvid]

Try to detect if file already exists, then delete it.

Use FileScripting Object... Can't find sample code... sorry, but pretty easy to use.



Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...