• Content Count

  • Joined

  • Last visited

  • Days Won


Leon last won the day on April 15

Leon had the most liked content!

Community Reputation

1 Neutral

About Leon

  • Rank
  1. 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...
  2. 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.