How can I open a specific Excel worksheet in a webBrowser control using vb.net? I can open a workbook using this, I would like to select a specific worksheet.
Dim x As frmExcelDisplay = New frmExcelDispla
x.Show(
x.AxExcel.Navigate("C:\mySpreadsheet.xls"
Thank
Gary
Paul Clement - 30 Apr 2004 20:08 GMT
¤ How can I open a specific Excel worksheet in a webBrowser control using vb.net? I can open a workbook using this, I would like to select a specific worksheet.
¤ Dim x As frmExcelDisplay = New frmExcelDisplay
¤ x.Show()
¤ x.AxExcel.Navigate("C:\mySpreadsheet.xls")
¤
Essentially you need to use Excel automation after the Workbook has been loaded (NavigateComplete2
Event):
Dim ExcelDocument as Object
Private Sub AxExcel_NavigateComplete2(ByVal sender As Object, ByVal e As
AxSHDocVw.DWebBrowserEvents2_NavigateComplete2Event) Handles AxExcel.NavigateComplete2
ExcelDocument = e.pDisp.Document
ExcelDocument.Application.Worksheets("Sheet7").Activate()
End Sub
Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)