Extracting Dimensions from a DWG for Inspection through Excel.

Extracting Dimensions from a DWG for Inspection through Excel.

owen_cookSYRW9
Explorer Explorer
115 Views
1 Reply
Message 1 of 2

Extracting Dimensions from a DWG for Inspection through Excel.

owen_cookSYRW9
Explorer
Explorer

Bit of a speculative post here, I am trying to find a quick way to take dimensions, and tolerancing, from a drawing, or model, so that they can be exported to an excel or word document and can be handed to another team to inspect the parts once they are machined, ensuring that they fit within the DWG's defined tolerances.

 

Currently I have found two ways;

exporting parameters from the model itself, taking the XML document into excel, which get very messy once the model gets too complex and is not very legible, nor does it show numbered tolerances.

Or I have found code for a rule that allows me to select various dimensions, currently it only allows me to add them as a reference in a table, some work is needed on it, and add them to a table which is only in the drawing.

 

My end goal is to have an easy process for taking the dimensions from the drawing, quickly taking all of them (tolerances, GDT etc. included) and being able to put them into a neat readable format so that the inspection team can inspect the machined parts.

 

I am asking for help to see if either of these ways is feasible, or if there is a better way of achieving it, or if it is not possible then I am not wasting too much time on it.

 

I have attached the code I found in this forum, unfortunately I do not know VBA, so any assistance on what to add would also be appreciated.

 

Thanks in advance.

0 Likes
116 Views
1 Reply
Reply (1)
Message 2 of 2

owen_cookSYRW9
Explorer
Explorer

As an update, I have found code, and modified it slightly, which is generating table close to what I am after.

My next steps are to try to get it to check how many decimal places a dimension is toleranced to (the company I work for has standard tolerances based on the decimal place count of a drawing, which is a fixed figure)

I also need the code to overwrite the standard tolerance if another value has been entered, and to pull all general dimensions, instead of dimensions marked as inspection dimensions.

 

I have attached the code, if anyone can help with my issue, it would be appreciated.

 

 

0 Likes