VBA webbrowser control not working in Excel VBA

Question

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.

Answer 1

Hi @Georgekutty, Renju

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

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.

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

If this is helpful please accept answer.

Answer 2

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.

Answer 3

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.