pivot tables from ASP

[Guest]

I'm interested in generating pivot tables from an ASP page and to that end I created a pivot table in Excel and saved it as HTML. I've looked at the generated code and carefully stripped out everything that doesn't seem to be necessary for the functioning of the pivot table, but I have two questions:

1) where do I find documentation on all the tags that I can use in Excel and what they do?
2) the generated output contains an HTML table and a cache file that contains all the data... the cache file seems to be used for regenerating the table when the user modifies it (e.g. moving a column from side to top) and if I comment out the HTML table the pivot table still works... my question is: how can I ask Excel to display the pivot table the first time (because it doesn't automatically do so)?

thanks in advance for any replies.

- e

 

[Guest]

Create in modul

Sub test()
Workbooks(1).WebPagePreview
end sub
Run this.
You can see the Excel Workbook in web browser.
You set WebOption object:
Workbooks(1).WebOptions