Overwrite HTML files

[kmacdonald]

I have a macro to export my report daily out to an HTML file. Is there a way I can get Access to automatically overwrite this and not prompt me to ask if I want to overwrite?
If not, is there a way to add something to the macro to say YES I do want to overwrite the file?

THanks

 

[teeitup]

Hi. I have this same need and problem. Did you ever find a solution to this problem?

I'm trying to "jury rig," this problem by creating a batch file, that executes before the macro and deletes the Output File, if it exists, then runs the macro.

There has to be a better way within Access.

VG