Export dimension coordinates from a drawing to Excel by catscript

[Froufrou]

Hi everyone,

Glad to join the community !
I have been searching here and on the web how to extract the coordinates of a drawing dimension, I hope you guys could enlighten me.

The goal is to export to Excel the dimensions from a drawing as it is done by the Marc Litzler catscript (

https://www.eng-tips.com/viewthread.cfm?qid=439565)

and I want to add the position of the dimension according to the drawing frame.
I guess it might be something like :

Dim xpos as double
Dim ypos as double
xpos = MyDimension.x
ypos = MyDimension.y
myworksheet.cells(i + 1, 7).Value = xpos
myworksheet.cells(i + 1, 8).Value = ypos

(This is in a loop, looping the selected dimensions)
I have also tried with MyDimension.AnchorPosition and others but none works.
Does any one know how to get that ?
Then, from the (x,y) position, I intend to attribute a frame position like C5 for example.

Thank you for your time !
François

 

[Froufrou]

Note that this code works if MyDimension refers to a text instead of a dimension.