Excel/Inventor automation

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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