Run-time error 429: The solution
Posted: 2016-11-03T07:59:39-07:00
When I first started to program VBA scripts to use IM with Excel, I run into the same problem as many others before.
caused an error message: Runtime Error 429 - ActiveX Component Can't Create Object
My search on this forum had only limited success, except that I found several topics about this problem.
The reason is rather simple: you have installed a 64-bit version of IM, but your programming environment is a 32-bit application, like my Office-365.
The simple solution: uninstall your 64-bit IM and reinstall a 32-bit version. Then everything works fine.
I'm not sure if there will be any disadvantages form this. Maybe IM runs a bit slower when you are working with very big images. I doubt that it's noticeable for human beings...
Code: Select all
Dim objIM
Dim myimage(1)
Set objIM = CreateObject("ImageMagickObject.MagickImage.1")
My search on this forum had only limited success, except that I found several topics about this problem.
The reason is rather simple: you have installed a 64-bit version of IM, but your programming environment is a 32-bit application, like my Office-365.
The simple solution: uninstall your 64-bit IM and reinstall a 32-bit version. Then everything works fine.
I'm not sure if there will be any disadvantages form this. Maybe IM runs a bit slower when you are working with very big images. I doubt that it's noticeable for human beings...