Excel VBA integration with SAM SSC.DLL

Start
Prev
1
Next
End

SolH
Topic Author

30 Oct 2017 21:40 #5810 by SolH

Excel VBA integration with SAM SSC.DLL was created 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

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

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

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.

Start
Prev
1
Next
End

Moderators: Paul Gilman

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.

NREL Home

NREL Research

Follow NREL

NREL is a national laboratory of the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, operated by the Alliance for Sustainable Energy, LLC.