Inventor Customization

Inventor Customization

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

Parte List Columns

191 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
petercharles
Posts: 1,101
Registered: ‎09-22-2005
Message 2 of 2 (161 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

Next

 

 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.