Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer of Dim text to excel program

Status
Not open for further replies.

marisse

Structural
Nov 15, 2004
22
Can somebody enlighten me on how can i get a dimension text value and transfer it to an excel worksheet.

Thanks
 
Replies continue below

Recommended for you

Do you know any programming?

"Everybody is ignorant, only on different subjects." — Will Rogers
 
I don't really know any programming, but i hope somebody is having the lisp command for this kinda thing if it does exist.

thanks anyway
 
One method using AutoCAD 2005... You can create a FIELD object within a TABLE that is equal to the value of the dimension and export the table to a CSV file...

Tracy Lincoln, TLConsulting
 
Do you need the dimension text to constantly update the Excel cell, or just when you run a macro, or do you want the Excel cell to be linked to the AutoCAD dimension so any change to either changes the other? Or something else?

Does the request to push the dimension text to Excel come from Excel or AutoCAD?

How many dimensions need to get to Excel?
 
Thanks twlincoln, i will check that out.

IFRs,
Actually i'll be needing it for door production purposes. I have to draw it in autocad then the door width and height value should be transferred to excel form for order entry. For every drawing i've created, the width and height should be extracted and send it to an excel form. In most cases,aound say 10 doors in one autocad drawings at a time, that means i have to extract 20 dimension values to be transferred to excel. I think a macro will do but i don't have any idea how to do this.

Thanks IFRs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor