I have a PivotTable in my Access database which I would like to automatically save as a webpage in a specific location on my web server.

Currently, I click the "Edit PivotTable" button which brings it up in MS Excel. I then go to File|Save As Webpage and select PivotTable functionality.

This action would be performed as the DB automatically loads up through the Windows Task Scheduler and opens a certain form performed through the startup options.

Could someone point me in the right direction?

Thanks.