VBA webbrowser control not working in Excel VBA

Georgekutty, Renju 1 Reputation point
2022-10-27T14:29:47.783+00:00

I tried to use web browser control with excel.

I have a VBA Project. Added User form. Placed a web browser on the form.

Initially it worked. But after some time it stopped function. The web browser stopped to open websites.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,658 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Dillon Silzer 54,931 Reputation points
    2022-10-27T15:25:24.907+00:00

    Hi @Georgekutty, Renju

    I just tried loading Microsoft Web Browser and go the message:

    254844-image.png

    From what I see, this functionality has been disabled due to security (as previously stated, IE is no longer supported and so aren't ActiveX controls). You should find a different method to achieve what you are trying to.

    If you are desparate to continue (which is not recommended) you could try opening regedit and going to the following key:

    Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Common\COM Compatibility\{8856F961-340A-11D0-A96B-00C04FD705A2}

    Change the value of Compatibility Flags from 400 to 0.

    254845-image.png

    ------------------------------------------------------

    If this is helpful please accept answer.

    0 comments No comments

  2. Georgekutty, Renju 1 Reputation point
    2022-10-28T07:33:49.47+00:00

    Hi @Dillon Silzer

    Thank you for your response

    We tried the registry edit solution you suggested, But still facing the same issue. Are you aware of any alternative to the web browser control.

    0 comments No comments

  3. Tom van Stiphout 1,701 Reputation points MVP
    2022-10-29T16:21:12.983+00:00

    The "workaround" is to open the browser itself as a separate app, rather than using the webbrowser control.

    MSFT is working on a new webbrowser control for Access, based on latest tech. Maybe when it comes out it can be used in Excel as well.

    0 comments No comments