I have a 40 page report which is used to generate static web pages. The report includes a subreport on the first page to index the other pages. I use a template to set up some navigation buttons.

Manually everything works fine with:
acPreview File¦Export and then navigate to destination / name.htm / type: HTML / template: xyz.txt

My users regularly get things wrong in the dialogs!

Can someone help with automating this?
I _need_ hard-coded path/name.ext/type/template

I've tried macros and doCmd****nCommand acCmdSaveAsHTML but I'm not making progress. SendKeys is not attractive!

Thanks for any pointers.

izy

Access2000/Win2000

OK, I found the answer elsewhere: in case anyone needs to know:

DoCmd.OutputTo acOutputReport, "myRpt", acFormatHTML, "c:/webpath/web.htm", False, "c:/tplpath/myTpl.txt"

izy