Overwrite Without Prompt

B

Bill

I have a need to export about 30 reports out of Access
2000 to a folder in html format on a daily basis. As it is
exporting, it prompts if I wish to overwrite the current
file. Up until now I was using a bat file to delete all of
the old files first so that I would not get this problem.

Well, thanks to our new security policy I can no longer
run bat files. I do not know VBA programming. Is there a
way to stop the prompting to overwrite in the macro?

Thanks

P.S.

I have already added the "SetWarning" line and set it
to "No" and it still prompts me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top