how can I insert an Excel spreadsheet in a Visual Basic 6.0 form

You can try the webbrowser control:  Projects>Components>Microsoft Internet Controls.


Private Sub Command1_Click()
    ' open excel file
    WebBrowser1.Navigate2 ("C:\Test.xls")
End Sub

Private Sub Command2_Click()
    ' save data
    WebBrowser1.ExecWB OLECMDID_SAVE, OLECMDEXECOPT_DONTPROMPTUSER
End Sub

you can try look for OLE object that available by default in VB6. You can select it from the ToolBox.

This will also load excels toolbar:

Private Sub Command1_Click()
    ' open excel file
    WebBrowser1.Navigate2 ("C:\Test.xls")
End Sub

Private Sub WebBrowser1_DocumentComplete(ByVal pDisp As Object, URL As Variant)
    WebBrowser1.ExecWB OLECMDID_HIDETOOLBARS, OLECMDEXECOPT_DONTPROMPTUSER
End Sub

hello vinnyd79:

I cannot find Projects>Components>Microsoft Internet Controls. do you know the path to the OCX or dll

thank you

sorry found it

It should be in your system32 dir:

shdocvw.dll

hello vinnyd79:

your solution seems to work but the problem is that unless i save the original excel file (which I don't want to do) i can not browser the spreadsheet and get the values on specific columns. is there a way that i can get to the content of the Excel spreadsheet?

thank you

Im not sure what you are trying to do. Do you have a new workbook that is open in Excel that you would like to pull into the vbform?

Try this http://support.microsoft.com/kb/311765 
it's the DSOFramer control, it works like Excel

hello vinnyd79:

i have placed the web control on the form like you suggested. i am able to display the Excel doc on the web component. the problem now is that I would like to access at the row and col level the content of the excel spreadsheet that the users will modify after following specific rules designed to accomplish a specific task (out of scope on this discussion). is there a way to access the content of the excel spreadsheet "currently" displayed on the web component?

thank you !