Hello All,

I have some macros that have been programed in VBA using Excel 2003/2007. Since our company has switched to 64 bit SolidWorks most of them don't work anymore. I have checked the references with in the VBA area and ensured that all of them are active and have the correct path.

Where I am running into problems is when I go to start a session of SolidWorks VIA the API from Excel, I get a

Run Time Error "429"

ActiveX component can't create object

under the debug it takes me to the line

Set swApp = CreateObject("SldWorks.Application")

Normally this is an indication that the reference library isnt loading correctly, or it is missing something.

Has there been a change from the 32 bit call to the 64 bit call? if so, what is the new call that I need to use? What else has changed?

Not sure if I will need to have 2 versions of the macros, one for 64 bit and one for 32 bit. If I do, any possible way for me to detect the system type from Excel and open the appropriate version?

Thanks in advance,

Adam