Create Web Pages
acCmdPublish
This example is based on an article by Mark Gillis of Microsoft called "Using Microsoft Access 97 to Share Static Data on the Web". This article seems to be no longer available on the Microsoft website.
It assumes that you have already set up some WebPage profiles in the Publish Wizard. The following code generates Web Pages based on the first profile.
'***************** Code Start *******************
'Code by Terry Wickenden
Sub ReportToHtml()
SendKeys " {DOWN}{DOWN}%F", False
DoCmd.RunCommand acCmdPublish
End Sub
'****************** Code End ********************