Export of Dimensions into Excel

[JoeMerry]

Hello all, i am trying to modify an existing lisp routine. I have next to zero experience in the writing/modifying of these routines.

The current one i am using (will be linked) exports the selected dimensions into excel with no issues but what i need to do is modify it so that every time i select a new stirng of dimension it adds it the same workbook. It currently opens new books every time you execute it. First pull goes in top row, second pull goes on second row...etc.

 

AutoCAD 2010 Mech

2010 Excel

 

Any help would be much appreciated.

ALDIMTXL.LSP

[SLW210]

Where did you get the LISP?

 

It was written by fixo, perhaps he will chime in.

[JoeMerry]

From this site?...have been hunting and pulling them down for long enough i dont remember to be honest.

[Tharwat]

I don't think it is a problem since the Author name hasn't been changed or removed by the OP .

[SLW210]

Try these threads.

 

how can I export the dimensions out into a file?

 

Dimension values to Excel

[JoeMerry]

Yeah, i would never remove that or claim credit for some of the brilliant work you folks pull off with these routines.

[SLW210]

I don't think it is a problem since the Author name hasn't been changed or removed by the OP .

 

Who stated anything about a problem?

 

Merely trying to find the thread he got the LISP from, best place to look for an answer to the question.

[Tharwat]

Yeah, i would never remove that or claim credit for some of the brilliant work you folks pull off with these routines.

 

This must be appreciated by all , thank you .

[JoeMerry]

Where did you get the LISP?

 

It was written by fixo, perhaps he will chime in.

 

 

Just realized i have been talking to Fixo via Autodesk forums as well, Hallex is his handle over there....

[JoeMerry]

Just wanted to update and say thnx to those that replied....Fixo is treating me like royalty and currently solving my issues. You The Man Fixo!!!

[Bradencn1]

What if I want to pull the dimensions as well as the x,y values of the endpoints of that dimension? How would I be able to do this? I want to see what the dimension value as it is written in, and then I want to have the x,y coordinates of the two endpoints that represents that dimension length.

[BIGAL]

Some of the dim properties that you can get using vl lisp.

 

;   ExtLine1Point = (449.435 425.783 0.0)
;   ExtLine2Point = (624.029 425.24 0.0)

;   Measurement (RO) = 174.594

;   TextOverride = ""

;   ObjectName (RO) = "AcDbAlignedDimension"