[This was originally published in my another blog on July 2016.]
Today I received a support request from a user who is facing issues while running a macro script. He was facing Run-time error 429 : ActiveX Component cannot create object.
Though I have never written macro, I decided to give a try. When clicked the debug button I got the following message.
OK. Data navigator is an internal software that we use for pulling some data. This message showed that this error has something to do with the Data Navigator. Its installed properly and is working fine when opening. However when compared to another PC which has no issue in running the script, found a small difference, there is a UAC Prompt in this PC when opening the software.
I am not sure why in some PCs it has this prompt while others not. Anyway I decided to find a way to remove this prompt and try again.
A quick google search brought me here.
Following the instructions, I downloaded and installed Microsoft application Compatibility toolkit. Once done, you will see 32 and 64 bit versions.
Take note that even if you have a 64 bit OS, the 64 bit version can only be used for 64 bit software. For my case, I have a 64 bit OS, but the data navigator is a 32 bit software.
Once opened the software, click on the Fix button.
Enter the necessary information.
Click Next and select the RunAsInvoker checkbox.
Click the
Test Run button to make sure that there is no prompt when opening the mentioned software.
Click Next and make sure that the RunAsInvoker is checked there also.
Click Next, followed by Auto Generate from the next screen.
Click
Finish
Now, we need to save the database. For that, click the Save button, and give the database a name.
Provide the save location when prompted.
Click on File, and then Install the database.
Now, click OK and close the Compatibility Administrator. Go to the Start menu and right-click your application, select properties and select the Advanced button. Make sure that Run as administrator checkbox is cleared. Click OK.
Now click the Compatibility tab, then Change settings for all users and tick the Run this program as an administrator checkbox.
VOILA !! We are done.
This made the macro to run properly, and made my user really happy. I hope this helps you all too.
