Overwrite Without Prompt

  • Thread starter Thread starter Bill
  • Start date Start date
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.
 
Back
Top