How do you embed an Excel worksheet in VB 6?

[ExcelGuy]

I need to insert an Excel worksheet directly onto a form in VB, but I can't figure out how to do it. There is an Excel worksheet insertable object that can be added to the program from the componants, but I can't figure out how to get it to insert worksheet into the object.
If anyone has any idea of how to do this, please respond right away. Your help will be greatly appreciated.

 

[daimaou]

you can use an OLE object on your form, then just choose Microsoft Excel worksheet for the object type.
Then you can choose the worksheet to use at design time or at run time(using the CreateEmbed method).

Let me know if u have more questions.

 

[VBRookie]

Check out this article:

http://support.microsoft.com/support/kb/articles/Q221/1/95.asp

I'm doing the exact same thing with my application and this was very helpful in showing me how.

Hope it helps.

- VB Rookie