VB.NET: Can't load Excel (.xlsx) into WebBrowser on Windows Form

Posted on 2013-01-06
Last Modified: 2013-01-07
I have all the references specified for using Excel and WebBrowser (Internet Tools .COM, etc.) and also use the following imports:

Imports Microsoft.Office.Core
Imports Excel = Microsoft.Office.Interop.Excel

Public oDocument As Object

However, after placing a WebBrowser1 on a Windows Form, calling on a file that is e.g. myfile.xlsx, and using the code below, the Webbrowser1 simply shows an info icon, and nothing happens.   Is there something I am missing?   (Note that the msgbox in the NavigateComplete2 never fires).

Also, how can I only show the column and row headers along with the sheet data, thus killing all the Excel menu commands and tools?   (I only want the user to see the gray-colored row and column headers along with the sheet data).  

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim filename As String


End Sub

Private Sub WebBrowser1_NavigateComplete2(ByVal pDisp As Object, URL As Object)
        MsgBox("NavigateComplete Event")
        On Error Resume Next
        oDocument = pDisp.Document
End Sub

Open in new window

Question by:lep1
  • 3
  • 2
LVL 44

Expert Comment

ID: 38749951
I assume the real file does actually exist in the path you specify.  
Check it - there are numbers of questions here where it doesn't when a path has been assumed.

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
        Dim filename As String


End Sub

Does the xlsx file actually open in excel when you double click on it from windows explorer ?

Author Comment

ID: 38750900
Yes, a VBA type of workbook opens with the data. I noticed on a forum that in VB.NET 2010 and newer Office ( I am using 2010 ), that Navigate won't open an Excel.  Rather an activeX control needs to be made.
LVL 44

Accepted Solution

AndyAinscow earned 100 total points
ID: 38751062
I've just made a small xlsx file in excel 2007 then typed the path into firefox.  It asks for how to open it (default of excel or browse for an app).  Looks like the forum is 'correct' in that a browser can't open the file natively.

Author Comment

ID: 38751156
Indeed, most forum posts regarding use of IE to open an Excel in webbrowser are 7-12 years old, and none address Office 2010 and Visual Studio >=2010

Author Comment

ID: 38751169
Interestingly the worst post claimed that not all your users would be able to open excel in webbrowser via ie due to variation in default sec settings. This is not good for excel and webbrowser

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# bracket error 3 30
updating order of the rows, N+1 query issue, C#,, MVC, SQL Server 3 25
get row value in 4 14
Powershell File Sort 8 24
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now