VBA Code required to export to HTML using template.

[Lensmeister]

Hi all,


I posted to another part of the forum but I havwe managed to locate some of the answers to my original post yet this one seems to allude me.

In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot more confusing.

I have a template named doc_tplt.html that when I do the export from the query it creates the webpage using this template.

I want to have a form with a selection of command buttons on it to export to html using the template for various queries and tables.

What I would like if someone can oblige is the VBA code to export the query (qry_docs) and apply the template (doc_tplt.html) and save to the same directory as the DB itself.

Can anyone help please?

Thanks in advance.

 

[pr2-eugin]

I have personally not used it, but DoCmd.OutputTo has an argument TemplateFile. Maybe that is what you are looking for.

 

[Lensmeister]

Thanks PR2

I have printed this off and will have a go at it.