Inventor Customization

Distinguished Contributor
Posts: 1,101
Registered: ‎09-22-2005
Message 1 of 2 (185 Views)

Parte List Columns

185 Views, 1 Replies
04-19-2011 09:06 AM

I've got a small macro to extract the data from 4 columns into an excel spreadsheet.

It works fine, but the columns required are hard coded into the macro.


I'd like to be able to scan across the columns for it's title and identify the required columns (item, part no, description, no off), particularly as I now find we use two parts list formats!!!

Distinguished Contributor
Posts: 1,101
Registered: ‎09-22-2005
Message 2 of 2 (155 Views)

Re: Parte List Columns

04-21-2011 08:51 AM in reply to: petercharles

Based on the old methods of trial and error ---



Dim oColumns As PartsListColumns
Set oColumns = oPartsList.PartsListColumns
Debug.Print oColumns.Count

Dim oColNo As Integer

For oColNo = 1 To oColumns.Count

Dim oColumn As PartsListColumn
Set oColumn = oPartsList.PartsListColumns.Item(oColNo)
Debug.Print oColumn.Title




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