I have Folder "C:/MyProject" with my Project. In this Folder exist my VB-Form with name "Form1" and HTML-Document with name "index.html".
The code HTML-document:
<html>
<body>
<object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1"></object>
</body>
</html>
In Form1 I insert Webbrowser1 and button Commad1 with this code:
Private WithEvents Exc As MSHTMLCtl.HTMLObjectElement
sub Form_load
Dim mHTMLDocument As MSHTMLCtl.IHTMLDocument
webbrowser1.navigate App.path+"index.html"
While WebBrowser1.document Is Nothing
DoEvents
Set mHTMLDocument = WebBrowser1.document
Set Exc = mHTMLDocument.All.SpreadSheet1
end sub
Private Sub Command1_Click()
Exc.Sheets(1).cells(1.1).Value = "Text"
End Sub
When I run my project, I see in WebBrowser SpreadSheet (like Excel-sheet).
When I press Command1 I change text in cell ("A1") in SpreadSheet1.
But how can I find ivents in SpreadSheet1. For exsample, when the user select cells or change text in any cell.
P.S. I'm sorry for my bad English