Excel VBA | Internet Explorer | OLE automation error RRS feed

  • Question

  • Issue: within an Excel workbook I'm trying via VBA to initiate/create a new Internet Explorer session with the following code, (Microsoft Internet Controls and Microsoft HTML Object Library are referenced)

    Dim objIE As New SHDocVw.InternetExplorer

    Set objIE = New SHDocVw.InternetExplorer

    the set objIE command line works fine on my workstation, but for several other colleagues they regrettably receive the infamous 'Microsoft Excel is waiting for another application to complete an OLE action."

    We've tried Excel in 'save mode', remove/disabled COM Add-ins, check marked the 'Ignore other applications that use Dynamic Data Exchange (DDE)' option. Two colleagues have even gone as far as having both MS Office (our office version is 2013 Pro Plus ( MSO and Internet Explorer (IE11 Ver: 11.0.960019698) completely reinstalled so we all have the exact same version, but regrettably to no avail since the OLE automation error still persist.

    Hence, can anyone help/guide give enlightenment since I have observerd on many an internet search that the infamous OLE automateion error even still exists within Office 365 etc.

    Thank you in advance.

    Thursday, June 18, 2020 8:57 AM