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
 
Back
Top