Excel VBA integration with SAM SSC.DLL

We're trying to integrate SAM's SSC.DLL within a VBA program in Excel (so we can invoke SAM from Excel).
However, we get the following error message:
Error 48: SSC.DLL file not found

Initially, we got the following error message but were able to fix it by copying the SSC.DLL to the windows\system32 directory:
Error 53: SSC.DLL file not found

Not sure what is going on?

Thanks,
Sol

Dear Sol,

I found two possible causes of the error.

1. The obvious cause is that VBA can't find the path to ssc.dll. You can fix that either by moving the file to a directory already in the path Windows environment variable as you did, or by adding the directory to either the user or system path.

2. The ssc.dll and Excel should both be either 32-bit or 64-bit. If you are using the 64-bit version of SAM and 32-bit version of Excel, then SAM's code generator includes the 64-bit version of ssc.dll in the package of files it created, and it will be incompatible with Excel. To fix that, replace ssc.dll with the 32-bit version that comes with your SAM installation: Replace ssc.dll with the one in c:\SAM\2017.9.5\win32. To find the version of Excel, go to File, Account, About Excel. To find the version of SAM, click Help, About.

UPDATE: As of SAM 2020.2.29, only a 64-bit version of SSC is available. SAM 2018.11.11 and earlier for Windows include both a 32-bit and 64-bit version of SSC.

Best regards,
Paul.

Thanks so much, Paul. It worked.
Apparently, I am running the default-installed 32-bit version of Excel (even though its a modern 64-bit machine with Windows 10) and the 64-bit installed SAM. Got it working for now. Will look into getting the 64-bit version of Excel so my the extensive parametric runs take full advantage of the machine.
-Sol

Hi Sol,

Here's some information from Microsoft about 32-bit and 64-bit versions of Excel and other Office programs:

Choose between the 64-bit or 32-bit version of Office

Best regards,
Paul.