ActiveX Microsoft Web Browser Object (embedding web page into excel file)

Question

I try to embed web page into .xlsm Excel 2010 file. That what I have made so far :
In Sheet1 I've inserted ActiveX control called 'Microsoft Web Browser' its default name is WebBrowser1 (Developer->Insert->More Controls->Microsoft Web Browser). Then using VBA editor I placed following code into sheet module Sheet1 :

Private Sub Worksheet_Activate()
WebBrowser1.Navigate "http://stackoverflow.com/"
End Sub

I've tried various websites and html files placed on my local hard drive but the content displayed in WebBrowser1 control is always the same - 'Internet Explorer Cannot Display The Webpage' error with no error from Excel VBA alone. It seems that Microsoft Web Browser Object can't establish connection to web page.

Leonardo Atalla · Accepted Answer · 2015-02-10 17:13:04Z

7

try this:

    'declare the web browser object for future reference and / or for listening to its events
    Dim WithEvents ie As WebBrowser

    'navigate when the worksheet is activated.
    Private Sub Worksheet_Activate()
        Set ie = ActiveSheet.WebBrowser1
        ie.Navigate2 "http://stackoverflow.com/"
    End Sub

answered Feb 10, 2015 at 17:13

Leonardo Atalla

3312 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Qbik Over a year ago

what does declaring with ` Dim WithEvents` change for properties of WebBrowser object ?

Leonardo Atalla Over a year ago

@Qbik The statement Dim WithEvents let's register the object in question so VBA can listen to it's event, much like for the worksheet object that expose by default it's events (onActivate , SelectionChange , ecc.). So for the WebBrowser , for example , you will be able to code on the OnQuit , onDownloadComplete events , and many more. It doesn't actually change it's property .

Mogsdad · Accepted Answer · 2016-04-19 14:03:13Z

-1

After Navigate you have to put parenthesis maybe that's why it cannot read the site. It should be like

WebBrowser1.Navigate("http://www.stackoverflow.com")

edited Apr 19, 2016 at 14:03

Mogsdad

46k21 gold badges166 silver badges289 bronze badges

answered Apr 19, 2016 at 13:06

Niki Kotsou

11 bronze badge

1 Comment

Smandoli Over a year ago

This isn't true. Either syntax is supported.

Collectives™ on Stack Overflow

ActiveX Microsoft Web Browser Object (embedding web page into excel file)

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related