CivilEA.com
  • Subscribe !
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Civil Engineering Association Civil Engineering Resource Civil Engineering Documents Engineering Spreadsheet Sap2000 Multiple Selection of Objects Tool

Sap2000 Multiple Selection of Objects Tool
 LiviuM

Professional Member

Retired Moderator
Christmas Island
User ID: 430
Joined: Jan 2009
Posts: 559
Threads: 90
Likes: 3,227 in 559 posts
Given Likes: 1705
Points:49,138 EP


#1
03-27-2011, 05:47 PM (This post was last modified: 03-27-2011, 06:09 PM by kowheng. Edit Reason: )
Sap2000 Multiple Selection Tool

[Image: info.png]
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]

[Image: Download.png]

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
***************************************

[Image: password.png]

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

.xls   Sap2000 Selection.rar.xls (Size: 490.7 KB / Downloads: 132)
Note: Remove file extension "xls" to get "RAR" file, then unpack "RAR" file to get excel files.



[-] The following 11 users Like LiviuM's post:11 users Like LiviuM's post
  • kowheng, Grunf, Dell_Brett, phanbao, robertsas, zainseiya, sasan7351, zimmermannn, bigone, haiquyppl1984, spat
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Multiple Excel Spreadsheets pezhmankhan 6 15,384 12-16-2019, 06:12 AM
Last Post: andersen3
  Multiple Excel Spreadsheets - RC + User Guide BennyP 14 31,394 10-30-2015, 01:22 PM
Last Post: PinkPant
  Multiple Excel Spreadsheets - STEELTEK rohailiyaz 2 9,684 09-30-2014, 11:16 AM
Last Post: bigone
  Multiple Excel Spreadsheets - LRFD Albert 2 8,621 06-10-2011, 11:52 AM
Last Post: 3fan
  Multiple Excel Spreadsheets - very, very interesting marion33 2 11,312 01-14-2011, 11:29 PM
Last Post: ravisbassi

  • View a Printable Version
  • Subscribe to this thread

Designed by CivilEA - Powered by MyBB

Linear Mode
Threaded Mode