Inventor General Discussion

Inventor General Discussion

Reply
*Tomassini Sandro
Post 1 of 3

How to automate this problem...

58 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.

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
Post 3 of 3

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.
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post