function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mihir Mehta 11Mihir Mehta 11 

"ActiveX component cannot be created" using VBscript on excel

We have a macro built out in excel that logs into salesforce and extracts some data. Lately since we moved onto a different server the macro no longer works and shoots us an error as listed below. 

"ActiveX component can't create object" .

On hitting debug, the error is generated at this line in the code:

Set binding = New SForceOfficeToolkitLib4.SForceSession4

I have compared the add-ins that we have for excel on this server and the old server and they are all the same, we do not know whats causing this issue. Any help / direction would be appreciated. 

Regards,
Mihir