×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Is it possible to extract all dimensions from a sheet?
2

Is it possible to extract all dimensions from a sheet?

Is it possible to extract all dimensions from a sheet?

(OP)
I would like to extract all dimensions from a sheet and list them in a table.
Currently I able to do this manually by double clicking a text box and then selecting a dimension to have its value appear.
I have little experience with macros but I don't know I would start this.
Any help would be greatly appreciated
 

RE: Is it possible to extract all dimensions from a sheet?

If you have a model, why not insert a design table and use all the dimensions used to create the part to populate the design table. No API programming and self contained in SW. After all the DT is an Excel spreadsheet.
 

RE: Is it possible to extract all dimensions from a sheet?

(OP)
THANKS  ALOT

RE: Is it possible to extract all dimensions from a sheet?

Someone also added to handleman's code for AddFlagsAndExportDims.swp which adds a balloon flag to the drawing dimensions and the excel output. Our quality specialist got pretty excited when he saw it this morning.

Thank you for sharing your code. It is appreciated. Diego

RE: Is it possible to extract all dimensions from a sheet?

Handleman,

I really like the idea of your macro but have run into a problem.  I followed all the comments in the previous thread, including changing all references to SwDim to mySwDim but I am getting the following error.

Compile Error:
ByRef argument type mismatch

The SwTool is highlighted in the following line.
xlSheet.Cells(CurRow, DIMTOLTYPECOL).Value = GetTolTypeName(swTol, NumTolVals, TolIsFit)

Not sure if it makes a difference but I am running SW2011 sp4.0.

If I run this after you macro for adding dimension balloon numbers after the dimension will this add that to a seperate cell in excel?

Thank you for your time and help,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources