CST - Access CSTResultReader.dll from EXCEL VBA

  • Thread starter Thread starter katto01
  • Start date Start date
  • Tags Tags
    Excel
AI Thread Summary
To control CST from Excel VBA and retrieve e-field values, users can reference the CSTResultReader.dll, although no specific Excel VBA examples are provided. However, examples in C# and Visual Basic .NET are available on the CST website, which can serve as a guide for creating a VBA routine. Another method to import CST project results into Excel is to save the data as an ASCII file and then read it into Excel. This approach offers a viable alternative for users seeking to manipulate CST data within Excel.
katto01
Messages
2
Reaction score
0
Hello,

I am trying to control CST from Excel VBA. For instance, I would like to create a routine in Excel VBA similar to the postprocessing template “Evaluate Field in arbitrary coordinates” into Excel VBA, i.e. get the e-field values into an array and insert them on an excel sheet.
I read the topic “CSTResultReader.dll” in the help but saw no example for Excel VBA. I am not a professional programmer, so I would need an example I could use to write my routine.
Please advise
Thank you

PS. Any suggestion on a different way that I could use to get the data from the CST project results into excel would be welcome.
 
Physics news on Phys.org
</code>Unfortunately, CST does not currently provide an example of using the CSTResultReader.dll in Excel VBA. However, you can find some examples of how to use the dll in other programming languages, such as C# and Visual Basic .NET, on our website: https://www.cst.com/content/cst/en/support/solutions/tutorials/fieldresultsreader.html. You may be able to use the examples provided to create your own routine in Excel VBA. Alternatively, you can save your results as an ASCII file and then read the data into Excel from there.
 

Similar threads

Back
Top