Existing Report SaveAs HTML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I save a Report - (Without opening it) in HTML format?
What is the code to do so?
I have 200 reports which I wish to perform this on.
Figured with the code I could Loop through the reports collection
and acheive..
any help appreciated.
 
Hi Jim

Should be possible with something like this:

Dim dbD As DAO.Database
Dim Doc As DAO.Document

Set dbD = CurrentDB
For Each Doc In dbD.Containers("Reports").Documents
DoCmd.OutputTo acOutputReport, Doc.Name, acFormatHTML, ....
Next
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save SaveAs menu item 1
Access 2007 - Use Report or HTML file as body of Outlook emailmessage 1
Email first report in HTML and second in Excell 2
Report RecordSources 1
SaveAs in Outlook - Detect type before the SaveAs 1
Access 2007 - Use Report or HTML file as body of Outlook email mes 3
Count number of open reports using VBA 7
Warning: The MantisTek GK2 keyboard has a built in keylogger 1

Back
Top