Export a report in HTML automatically

  • Thread starter Thread starter Frank B
  • Start date Start date
F

Frank B

In VBA, I want to Open a report (no problem), but then I
want to Export the report in HTML to say "D:\Myfolder,"
and call it "MyReport.HTML". I thought this would be easy,
but I'm stumped. Is there a way to do this without putting
code into the report's "On Activate"? Thanks for your
reply.... Frank
 
Which version of Access are you using? I'm still using Access 97 and it's
easy to export a report (as long as you don't want to keep lines and stuff -
that's an MS Access 97 problem) by highlighting the report in the Database
window and selecting File=>Save as HTML. You can create a special file that
Access will read as a template and insert the report where it finds the
<!--AccessTemplate_Body--> tag.

Are you looking for a way to automate this? You could create a macro,
couldn't you?

Ted
 
Thanks for your reply. I am using Access 2K. I need to
run and export/save this report as HTML from the click of
a button without manual intervention. I know how to do
everything except programatically:
"EXPORT the Report as HTML using a provided path and
filename."
I thought this would be easy, but (for sure) I thought
someone would offer an embarrassingly simple solution.
The more I know, the less I know :-)

Thanks for any help or clues.... Frank
 
Ted:
It is NOT the Report I want to export as HTML... It is
the data the report generates I want to save as HTML. I
guess I was not clear on that point. Thanks, again.....
Frank
 
DoCmd.OutputTo
is exactly what I needed. Why this is called EXPORT on
the menu bar, and OutputTo in VBA is beyond comprehension.
At the very least Help searches on Export, could have
advised and would have been thoughtful.

Now, when you run OutputTO the screen flickers with
progress windows, and SetWarnings does not suppress them.
Any idea how to do that? ... Frank

PS: Running Access 2000
 
Back
Top