var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: automate report export to html
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.RunCommand acCmdSaveAsHTML but I'm not making progress. SendKeys is not attractive!
Thanks for any pointers.
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"