Inventor General

Active Member
Posts: 6
Registered: ‎11-15-2012
Message 1 of 3 (496 Views)
Accepted Solution

Excel driven general tables and vba object hierarchy

496 Views, 2 Replies
12-10-2012 09:18 AM

Running Inventor 2010 on XP 32 bit platform.


I've got two questions of entirely different nature... hopefully I'm not breaking any forum rules or unwritten formalities by asking them in the same post; I'm new to the forum.


1. I'm using Excel driven general tables for my parts list in idw's and I would like to select a "Data Start Cell" from another sheet in my Excell workbook other than sheet1. I tried typing "Sheet2![cell_no]", but this is not a valid entry. Is there any way to accomplish this or am I stuck picking a cell on sheet1 of my workbook? It's not a big deal if I'm not able to select a cell from another sheet, but it would be nice simply for organization.



2. Does anyone know of a good resource that would provide a more thorough description of Inventor classes and objects for vba? The help function is fine for finding out what classes and objects actually exist and the sample code examples give a little more insight, but it would be helpful if there were a resource that provided a little better description of object functionality. I could get by with the sample code and help, but it would certainly help to have an extra resource.





*Expert Elite*
Posts: 891
Registered: ‎11-13-2006
Message 2 of 3 (463 Views)

Re: Excel driven general tables and vba object hierarchy

12-11-2012 04:59 AM in reply to: nkopilec

Hi Nkopilec,


The best resource for Inventor programming is the Autodesk Developer network... But you do have to pay to join!

Check out there site here, there is some free stuff to whet your appatit:


You can download the developer tools MSI for free - which includes a handy PDF map of the Inventor API object model.


have fuin,




(P.S. someone else will have to answer your excel question!)

The CAD Setter Out Blog @CadSetterOut

Inventor Surfacing | AutoCAD | CAD Standards
Please use the Mark Solutions! Accept as Solution or Give Kudos! Kudos functions - Thank you!
Active Member
Posts: 6
Registered: ‎11-15-2012
Message 3 of 3 (447 Views)

Re: Excel driven general tables and vba object hierarchy

12-12-2012 05:47 AM in reply to: nkopilec

Thanks for your reply. The tree diagram of the object hierarchy was very helpful.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community

Inventor Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Autodesk Inventor helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Inventor