VB in Access , Need code to confirm overwrite message box.... 1

[Moostang]

I am exporting a form to an htm file but it keeps prompting me "Do you want to replace the existing file?" . I need to automate this by auto selecting yes.

Public Sub Export()
DoCmd.OutputTo acOutputForm, "Node Summery: Today Subform (By Time)", acFormatHTML, "c:\aftp\quicksum.htm", False, "c:\template.htm"

Above is the code I used to export. Like I said, I need to automate this but cannot seem to figure out how to disable the replace prompt or auto select yes on it.

Any help would be appreciated.

 

[scriverb]

Try these modifications:

Public Sub Export()
DoCmd.SetWarnings False
Kill "c:\aftp\quicksum.htm"
DoCmd.OutputTo acOutputForm, "Node Summery: Today Subform (By Time)", acFormatHTML, "c:\aftp\quicksum.htm", False, "c:\template.htm"
DoCmd.SetWarnings True
End Sub
The Kill statement deletes the file before you try to export the same file out to the path. This should get rid of the problem with ACCESS asking if you want to overwrite. I included the SetWarnings commands to take care of any other extraneous prompts that may pop up.

Let me know if this works for you.
Bob Scriver

 

[Moostang]

Awsome, that works great!

Thanks for the help and quick reply!