VBA in Excel: "Cannot create ActiveX component" when automating SolidWorks Composer – regsvr32 fails

Hi all,

I'm trying to run a VBA macro from Excel to automate SolidWorks Composer. My goal is to automatically generate Composer outputs and export them into a .docx document. However, when I run my code, I get the following error:

Run-time error '429': ActiveX component can't create object

I'm using this line in my VBA code:

Set composerApp = CreateObject("Composer.Application") 

To troubleshoot, I tried registering composer.exe as a COM server using:

regsvr32 composer.exe

My questions:

  • Is this error caused by missing files, a licensing issue, or something else?
  • Is there a specific way to register SolidWorks Composer for COM automation?
  • Do I need to install extra components or libraries for this to work from Excel VBA?
  • Has anyone successfully automated Composer from Excel, and if so, what steps did you take?