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

[cadddict]

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

 

[handleman]

thread559-173312

-handleman, CSWP (The new, easy test)

 

[progdie]

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.

 

[cadddict]

THANKS ALOT

 

[DiegoLGraves]

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

 

[Gupta65]

@Diego you might find

http://www.inspectiongeni.com

helpful too.

Deepak Gupta
CSWE, CSWP
SW 2011 SP5.0 & 2012 SP1.0
Boxer's SolidWorks™ Blog

 

[GRF]

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,