Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    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.

    izy

    Access2000/Win2000

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Talking

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •