Excel VBA integration with SAM SSC.DLL

  • SolH
  • Topic Author
  • New Member
  • New Member
More
30 Oct 2017 21:40 #5810 by SolH
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

Please Log in or Create an account to join the conversation.

  • Paul Gilman
  • Paul Gilman's Avatar
  • Platinum Member
  • Platinum Member
More
31 Oct 2017 17:22 - 21 May 2020 17:39 #5811 by Paul Gilman
Replied by Paul Gilman on topic Excel VBA integration with SAM SSC.DLL
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.
Last edit: 21 May 2020 17:39 by Paul Gilman.

Please Log in or Create an account to join the conversation.

  • SolH
  • Topic Author
  • New Member
  • New Member
More
01 Nov 2017 01:20 #5812 by SolH
Replied by SolH on topic Excel VBA integration with SAM SSC.DLL
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

Please Log in or Create an account to join the conversation.

  • Paul Gilman
  • Paul Gilman's Avatar
  • Platinum Member
  • Platinum Member
More
01 Nov 2017 16:14 #5813 by Paul Gilman
Replied by Paul Gilman on topic Excel VBA integration with SAM SSC.DLL
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.

Please Log in or Create an account to join the conversation.

Moderators: Paul Gilman
Powered by Kunena Forum