Leon

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

Share this post


Link to post
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...

  • Like 1

Share this post


Link to post
Share on other sites