Microsoft vba CreateObject statement open Maxthon mistakenly


Recommended Posts

I have come across the same problem reported on following topics that the maxthon may mess up some window registry settings. That dated back to as early as 2005!

https://www.mjtnet.com/forum/viewtopic.php?t=2287

https://answers.microsoft.com/en-us/msoffice/forum/all/vba-ie-automationexcelaccess-in-window-10-wrongly/2933fac7-41e4-49b8-ac73-ad8d037ff90b?auth=1

Sub CreateIE
Set IE = CreateObject("InternetExplorer.Application")
IE.visible = 1
End Sub

The above code written in a vba application such as Microsoft Access mdb module should start an internet explorer. But in a pc installed with maxthon, it open the maxthon instead. Uninstall maxthon does not solve it. The programmers on maxthon should do some test and fix it.
 

maxthonError.jpg

Link to comment
Share on other sites

Finally I found the solution of this lifelong not solved problem: the executable file (.exe) needs to be run with administrator rights.

Reference:
VB2008 GetObject throws Cannot create ActiveX component exception but Excel VBA works fine

https://social.msdn.microsoft.com/Forums/en-US/6b8b95b5-e002-4741-84e6-e48de64eefa7/vb2008-getobject-throws-cannot-create-activex-component-exception-but-excel-vba-works-fine?forum=vbinterop

The solution is pretty frustrating: you have to run CATIA as an administrator...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.