Macro to generate the Report of Distance between the parts.

[Abhi9154]

Hi,

This is my 1st Post in Eng-Tips.
From my past experience i have found many valuable information in this Forum.

I have an assembly which consist of nearly thousands of Plates(Parts).
I want to generate a report which consist of distance between the plates.
If the Distance between the plates is greater than 150mm it should be marked in a colour.
Report may be in xls or xml format
I know i'm being direct but i need this urgently!!!!!
Please Help.


Thanks in advance.

 

[itsmyjob]

search "distance between parts" in this forum give me this one in 4th postion in about 1 sec

thread560-353269

Eric N.
indocti discant et ament meminisse periti ​

 

[Abhi9154]

Thank u So much for your valuable response.

I have a question here :

we can have a macro where the user can select the parts and reference to measure the distance?

 

[itsmyjob]

you can do plenty of stuff with a macro, that could be part of it

Eric N.
indocti discant et ament meminisse periti ​

 

[Abhi9154]

I want to generate a report consisting of distance between the plates (parts)
if the distance between the parts is less than 120mm it should be highlighted..
please help me..

 

[ferdo]

Please do not duplicate posts, keep the forum clean...

Regards
Fernando

https://picasaweb.google.com/102257836106335725208

https://picasaweb.google.com/103462806772634246699/

 

[Abhi9154]

Hi,

I have been struck while executing a Function,
I needed to calculate the distance between various parts
I compiled a macro which calculated the distance between all the parts according to Tree Specification,and Exported the Result in Excel.
But the Parts in the design are not according o Tree Specification.
Now the requirement is
I need to Ask the user to select a bunch of parts and run the Command which will calculate the distance.M struck here.

Please help!