Inventor General Discussion

Inventor General Discussion

Reply
*Tomassini Sandro
Message 1 of 3 (53 Views)

How to automate this problem...

53 Views, 2 Replies
05-23-2007 02:54 AM
Dear all,

I have the gravity center coordinates of more than 2000 objects in a
excel spreadsheet. The idea is to create an assembly made of a layout of
workpoints and cubes with the length side read from the same
spreadsheet and constrained in the center of gravity.
The macro should create the layout of workpoint, for each workpoint the
cube and then the final assembly placing each cube in its position.

Could someone help me?

I thank you all in advance

P.S. In attachment you can find the model of spreadsheet.
*MarcoA
Message 2 of 3 (53 Views)

Re: How to automate this problem...

05-23-2007 03:15 AM in reply to: *Tomassini Sandro
il giorno 23/05/2007 11.54 Tomassini Sandro ha scritto:

> I have the gravity center coordinates of more than 2000 objects in a
> excel spreadsheet. The idea is to create an assembly made of a layout of
> workpoints and cubes with the length side read from the same
> spreadsheet and constrained in the center of gravity.
> The macro should create the layout of workpoint, for each workpoint the
> cube and then the final assembly placing each cube in its position.


This link contain what could be a starting point:
http://www.xanadu.cz/en/apps/importcoord/

M.
*Duncan Anderson
Message 3 of 3 (53 Views)

Re: How to automate this problem...

05-23-2007 03:28 AM in reply to: *Tomassini Sandro
Or you could download Read Points from File from
http://www.kwikmcad.com/icode/macros.asp and change the line that puts a workpoint
at the coordinate to a routine that imports a pre-made cube.ipt to those
coordinates.

For more info on VB(A)
Inventor Customization (VBA and VB)
http://discussion.autodesk.com/forum.jspa?forumID=120
news://discussion.autodesk.com/autodesk.inventor.customization


--
Duncan
"Humour ... is one man shouting gibberish in the face of authority, and proving by
fabricated insanity that nothing could be as mad as what passes for ordinary
living."
(Terence 'Spike' Milligan K.B.E., 1918-2002)
www.autodesk.co.uk/inventorjobs
http://support.microsoft.com/default.aspx/kb/555375


"MarcoA" wrote in message
news:5594769@discussion.autodesk.com...
il giorno 23/05/2007 11.54 Tomassini Sandro ha scritto:

> I have the gravity center coordinates of more than 2000 objects in a
> excel spreadsheet. The idea is to create an assembly made of a layout of
> workpoints and cubes with the length side read from the same
> spreadsheet and constrained in the center of gravity.
> The macro should create the layout of workpoint, for each workpoint the
> cube and then the final assembly placing each cube in its position.


This link contain what could be a starting point:
http://www.xanadu.cz/en/apps/importcoord/

M.
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.