Civil Engineering Association

Sap2000 Multiple Selection Tool

This excel worksheet contains macro (visual basic script) to connect to sap2000 V11, V12, V14 API and select a list of elements.
Because sap interface allows the selection of a single item this worksheet is useful to select multiple items.
Elements frame, joints, shells.
Warning the worksheet keeps previous selection, sap interface will update after a zoom/pan action.

For those trying to develop tools for Sap API read SAP2000_API_Documentation.chm located in sap instalation folder next to sap2000.exe. And you can start with this worksheet.

First steps, have to be done only once:
1) Open this worksheet in excel
2) Add reference to sap2000.exe. (Follow the steps as shown in pictures inside excel document).
3) Save the worksheet.
4) Repeat first step for every version of Sap you have installed, and save a copy of the worksheet accordingly.

How to use, after first steps:
1) Open worksheet in excel. (If in windows Vista, 7 with UAC enabled, read below Note).
2) Paste the list of labels in the first column (A:A)
3) Click button according to the object type.
4) Repeat from step 2 as much as you like.

Warning if there is more than one sap2000 open, the worksheet will work only with one of the instances, usually the first instance, sometimes at random.

Note: For those with Vista or Windows 7, with UAC enabled, you must run Excel and Sap2000 as administrator.
In order to do that browse to:
Windows x86
C:\Program Files\Microsoft Office\Office..\excel.exe
Windows x64
C:\Program Files (x86)\Microsoft Office\Office..\excel.exe
create a shortcut on desktop, right click on the shortcut->properties->compatibility, check [ ]Run this as administrator.
Each time you what to use the worksheet open excel with that shortcut, then open the worksheet.

If you encounter automation error it's because:
- The reference to sap2000.exe is wrong
- Sap2000 or Excel are have no administrator rights
- You don't have license for sap2000.

0.5 MBytes, two files included:
Sap2000 Selection.xls
Sap2000 Selection.xlsm

[Image: 77628772550592278241.jpg]

Code:
***************************************

Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html

***************************************

Code:
***************************************

Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html

***************************************

Direct Links: thumbup

[attachment=1127]
Note: Remove file extension "xls" to get "RAR" file, then unpack "RAR" file to get excel files.

LiviuM