ETABs API- Sapmodel

[Hoda_S]

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.

 

[zapa07]

Hey there. I read that people having trouble comnecting vba to Etabs version 22. And so far there were no solution.

 

[sticksandtriangles]

Is "myETABSObject" created?

Have you tried this from the sample code provided with ETABS 22 documention?

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.