VBA - Excel SAP2000 API - Automation Error

Question

I am trying to start SAP2000 using VBA Excel but I get an error with the message: "Automation Error". The code is very simple:

Sub api()

Dim SapObject As Sap2000.SapObject
Set SapObject = New Sap2000.SapObject
SapObject.ApplicationStart

End Sub

This code should start SAP2000 but it does not.

SAP2000v14 is installed along with Office 2013. I have checked the tick box next to SAP2000 in Tools-References menu.

By the way, I can run SAP2000 using MATLAB.

Thank you!

Did you try Dim SapObject As New Sap2000.SapObject and omit the Set line? — Mr. Mascaro
– Mr. Mascaro, Commented Nov 20, 2014 at 14:38
try late binding, have you got reference to the SAP2000 API? — user2140173
– user2140173, Commented Nov 20, 2014 at 14:57
what is late binding? i have checked the tickbox next to SAP2000 in tools-references in VBA editor. — cagri
– cagri, Commented Nov 20, 2014 at 15:08

cagri · Accepted Answer · 2014-11-20 16:39:37Z

1

Thank you guys. But I have sorted it out. In the compability options of SAP2000.exe, "run as admin" was selected. So I deselected it and it works now.

answered Nov 20, 2014 at 16:39

cagri

718 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user812786 · Accepted Answer · 2016-10-06 18:43:07Z

1

Here is code for SAP 2000:

Option Explicit

  Dim SapObject As SAP2000.SapObject
  Dim ret As Long
  Dim Coordinates As Range
   Sub Sap2000_open()


  ' Create the Sap2000 object

      Set SapObject = CreateObject("SAP2000.SapObject")

      SapObject.ApplicationStart
      SapObject.SapModel.InitializeNewModel (kgf_m_C)
      ret = SapObject.SapModel.File.NewBlank

End Sub

edited Oct 6, 2016 at 18:43

user812786

4,4306 gold badges42 silver badges50 bronze badges

answered Oct 6, 2016 at 17:24

user6933448

111 bronze badge

Collectives™ on Stack Overflow

VBA - Excel SAP2000 API - Automation Error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related