How to make Microsoft Web Browser object work in Excel 2016

excel vba excel-2016
AlKoral picture AlKoral · Jan 26, 2016 · Viewed 22.7k times · Source

When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known issue with former Excel versions, but I couldn't find any support for 2016.

Has anyone been able to make this work?

Here are screenshots:

Answer

barrowc picture barrowc · Jan 28, 2016

This appears to be intentional behaviour from Excel 2013 onwards. From this article:

This issue occurs because some scriptable controls are made obsolete in Office 2013 for security reasons. This is by design, and these errors are expected.

There is a workaround posted in that article which involves editing the registry to make these controls work again.

(The KnowledgeBase article was originally linked from this Microsoft community thread from 2014)

Related questions

How to reference and refresh a QueryTable in Excel 2016 in VBA

I'm trying to refresh a query on a cell change, however I can't figure out how to reference the query. My code: Sheets("Roster Query").QueryTables(0).Refresh Just errors out with: Run-time error '1004': Application-defined or object-defined error I …

Read More
Can't find Microsoft Forms 2.0 Object Library or FM20.DLL

In my Excel 2016 project (Windows 7), I'd like to work with the clipboard: Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard But I've got this compiler Error at the first line of code: User-defined type not defined So I would like …

Read More
How to call a function on ENTER key in Excel using vba

Google should provide me with ample examples but none of them seem to work What I want: Everytime the user presses, and then releases, the ENTER key, for my program to do do something (ie. create a MsgBox, or call …

Read More