Excel/Inventor automation

Excel/Inventor automation

Anonymous
Not applicable
449 Views
1 Reply
Message 1 of 2

Excel/Inventor automation

Anonymous
Not applicable

Guys,

Hoping to get some thoughts and ideas on how to accomplish this.

 

Goal is to have what i call a "non attended" process.Where the user does not need to have knowledge of Inventor.

 

Where the user completes a spreadsheet (make selections,input some data).Once complete he/she can select to open Inventor (invisibly) open a assembly and update/run the ilogic rules contained within that assembly. I am thinking to have a command button on the spreadsheet which would do this.

Once model is updated drawings are created in idw, dwg and pdf formats.

All files saved in a new folder.

 

All with minimum user interaction

 

 

 

Some of the questionsi have  are 

 

Curently i have the worksheet be linked to the assembly, is there a better way? Maybe use the GoExcel Application in ilogic to "read" the values?

How to start inventor from the worksheet  and open the model?

How to make sure all rules within the assembly(and sub-assemblies,parts) run? Remember the user will not be able to use the itrigger

 

ideas, pointers will be much appreciated.

 

I am doing this in Inventor 2009 and Excel 2000

 

0 Likes
450 Views
1 Reply
Reply (1)
Message 2 of 2

Jef_E
Collaborator
Collaborator

I would use a standalone application (plugin) then do excel and Inventor jobs from there.

and In this case never touch the iLogic if you want all to be invisible for the user.

 

http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=17324828

 

An addin could also be used but I don't know if it can be used without any user interaction from inventor.



Please kudo if this post was helpfull
Please accept as solution if your problem was solved

Inventor 2014 SP2
0 Likes