Excel spreadsheet on form.

[ddivers]

I have placed a excel sheet on my form by going into Components, Insertable Objects tab, and then selecting MS Excel Worksheet.

Does anybody know how I can edit the contents of each cell in the Excel sheet on my form. I do not want VB to open up excel, and show the form in Excel, I would like it to display everything on the form. I cannot figure out how to edit the cells, or load a .xls file into the object. If an example is needed, I will glady post one, or if someone needs clarification, I will try my best to clarify. Thanks.

[ddivers]

...

[ddivers]

Decided to use FlexGrid instead, much easier and basically the same thing. If anyone needs any help having a FlexGrid in their form, and or manipulating it, I can probably help you.

[ashky]

dear ddivers,

Can you post some code on How you move the contents of a Excel file to a Flexgrid. I am working in something similar to what you said. How do you tackle the rows and columns. I mean , How is the Flexgrid reacting if the excel spreadsheet is very very large.

thanks in advance...,

ashky.

[ddivers]

When I get home I will see what I can do. I have not actually taken the information from excel and put it on a flex grid. I take my information from flex and put it on the excel sheet. Im sure i can help though.

[rudvs2]

hey ddivers Hope you have got things sorted if not just give me a buz

ps to use the excel object insert an ole control on to your form

in the form load place this

OLE1.CreateEmbed "c:\my documents\test.xls", "Excel.Sheet.8"

where Ole1 is the name of the ole control you have created

the path is the full path to the excel document you want to open.

and excel.sheet.8 is the class type that the ole object is going to use to open the document