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
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?
-handleman, CSWP (The new, easy test)
RE: Is it possible to extract all dimensions from a sheet?
RE: Is it possible to extract all dimensions from a sheet?
RE: Is it possible to extract all dimensions from a sheet?
Thank you for sharing your code. It is appreciated. Diego
RE: Is it possible to extract all dimensions from a sheet?
Deepak Gupta
CSWE, CSWP
SW 2011 SP5.0 & 2012 SP1.0
Boxer's SolidWorks™ Blog
RE: Is it possible to extract all dimensions from a sheet?
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,