Excel macros and inventor

[Anonymous]

Has anyone used or setup a macro in excel to work on the inventor? For an example, where you can go into a sheet in excel and enter some dimension and hit a button and it draws it up in inventor for you? I have worked with something like this before using Solid Edge program. Not sure if posted this in the right forum. I was just wondering about this and figured i would ask about it. 

[S_May]

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/CloudHelp/cloudhelp/2015...

https://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/CloudHelp/cloudhelp/2016...

[Anonymous]

Thank you for the links. Can you use the ipart to do assemblies also or is it just parts?

[S_May]

Hi @Anonymous,

Here are patterns for iparts.

[Anonymous]

Thank you for the link again. My question was can you do a assemble as an ipart?

[S_May]

iPart in assembly

ipart is only for models, for modules there is ilogic
or assemblies over master sketch as ipart

[Anonymous]

Ok. I will have to play around with this and try to learn how to do it. I just was wondering if you could use excel with inventor.

[MechMachineMan · Accepted solution]

As far as vb/vba/macros: Yes. Both API's are accessible. It really doesn't matter where you run them from as long as they can connect to inventor.

As far as non-programming related: Yes. You can embed excel spreadsheets, use iLogic, and they are an embedded part of positional representations and linking parameters.

[Anonymous]

Where can i find information on this? I would like to read up on it and try my hand on doing some of this. I'm trying to learn all the stuff I can with inventor. Thank you.

[MechMachineMan]

Inventor customization forum has a lot of posts (see especially the stickies "My First Plug-in") My forum signature has some links in. The autodesk reference material for iLogic has some.

The Programming Help available offline through inventor (question mark dropdown in top right corner of application window), or online through the autodesk help > developer documentation also has a lot of info.