I'm trying to get some data form an open etabs22 file in excel VBA. This is my code:
But i get this error:
As you see, there is a problem with 'SapModel'. Any ideas on how to solve?
Thank you.
Have you tried this from the sample code provided with ETABS 22 documention?
Code:
Visual Basic for Applications (VBA) via Excel
'create an instance of the ETABS object from the latest installed ETABS
Set myETABSObject = myHelper.CreateObjectProgID("CSI.ETABS.API.ETABSObject")
I don't work in VBA, but have accessed the API before in Python and C#. Just taking some guesses at this point.