Save As HTML - automate - Access 97

[Dr. Mark Rhodes]

Hi, Friends.

I'm hoping someone will help me think through this problem.

I want to automate the 'Publish to the Web' wizard in Access 97. When you
select 'File' and 'Save As HTML' the wizard pops up to gather information
from the user. I presume this information is turned into parameters that are
passed to a DLL or EXE.

Is it possible to call that function and pass parameters programmatically? I
certainly would be grateful for further information. Function name and
documentation would be most welcome.

Thanks.

Mark


****************

Context...

Access 97 database working very well for 10 years.
Now client wants (more or less) live web output.
Saving certain reports as static HTML (to the web server) works very well
manually.
Data in tables change througout the work day.


Ultimate goal...

Live web access to reports (executable producing dynamic reports, bigger
project).


Short term goal...

To automate the Save As HTML so it recreates the web page reports every 15
minutes.
I have code in place to run a function every 15 minutes. I just don't know
what the function would be called.

 

[strive4peace]

Hi Mark,

look up help for
OutputTo Method
SendObject Method

a quick way to get help is this:

press CTRL-G to goto the debuG (Immediate) window

type/paste the command you want to look up

press F1 or, click on the keyword with your mouse and press F1


Warm Regards,
Crystal

*
have an awesome day
*

 

[Dr. Mark Rhodes]

Ah, Crystal.

That looks like just what I was after. I'll do a little testing and let you
know.

Thanks.

Mark

 

[strive4peace]

you're welcome, Mark happy to help

Warm Regards,
Crystal

Access Basics (Access MVP site)
http://www.accessmvp.com/Strive4Peace/Index.htm
8-part free tutorial that covers essentials in Access

*
have an awesome day
*

 

[Dr. Mark Rhodes]

Crystal,

The OutputTo calls have been working beautifully for about 24 hours now -
recreating 70-100 static pages every 15 minutes. Many happy folks on this
end.

Thanks so much.

Mark

 

[strive4peace]

Hi Mark,

very glad to hear that! thanks for letting us know, we love happy folks
<smile>

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
have an awesome day
*