Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • 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
Joined
Nov 15, 2004
Messages
22
Location
AE
Can somebody enlighten me on how can i get a dimension text value and transfer it to an excel worksheet.

Thanks
 
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

Back
Top