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 have a query in Access that pulls information from a remote database. I then put that data into a local table and export that table to excel. I have a workbook that has a spreadsheet setup to get it's information from the information exported table. I want to be able to export the data from...
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.