Call SAM using Excel VBA

Hi Paul,

Is it possible to call SAM directly from EXCEL using vba code?
I think it could since the code generator can generate vba code. I try that but it generated a bunch of csv files, I go through them and could not figure out where the vba code sits?
Could you point me to the code or provide me with an vba call SAM example?

Thanks,
Xinyue

Dera Xinyue,

Yes. You can use SAM's code generator to generate VBA code, and then use that in Excel.

When you use the code generator, you should see a bunch of CSV files that store inputs that are large arrays or tables along with a .bas file that contains the code. For example, if you run the code generator from a case named "untitled," you should see a file named untitled.bas along with the CSV files you mentioned, and copies of th ssc.dll and sscapi.h files

Also, to see other discussions about using VBA with SAM, see these search results:

sam.nrel.gov/search/site/vba

Best regards,
Paul.