ASP component to display excel spreadsheet

[silversurfer]

Hi there!

I try to build an ASP component with VB, which reads in an excel spreadsheet and diplays it as a asp page.
I am relativley new to ASP Components and VB, and all I managed so far is opening Excel with a click on an asp page button...

Aeh, but i don't want stop here. Where can I get a good description of all the built in objects an properties? Or maybe there is somebody out there who can give me a bit of advice how to get into this built in object stuff. Is far as I know, there are plenty of object and methods out there, but how to access/use them would be helpful to know

I know that I have to reference to different object libaries in VB, thats not the problem. But for example if I have opened an application, how do I create a new doccument, or open an excisting one and write/read from it?

Your help is much appreciated!

 

[caf]

Hi

Once you've set your reference to Microsoft Excel <Version> Object Library, you can call the Object Browser <F2>. Select Excel from the Combo box and you should see all the properties, objects & methods etc of the excel object.

As for examples, you choose a method, property etc & press F1. Most properties have associated examples.

http://msdn.microsoft.com/library/default.asp?URL=/library/books/advnvb5/ch03_35.htm

Is one of the sites you can visit. I'm sure some other guys in this forum can point you to invaluable resources (I unfortunately learnt COM/Automation the hard way and can only teach it that way ;-)

Have fun
caf