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...
I'm trying to export a table to excel, that part works fine, but is there a variable or anything else that I can add to the code or macro to export it to a specific sheet within an exsisting excel workbook?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.