Inventor General

*Trull, Michael
Message 11 of 14 (57 Views)

Re: iParts - Did you know?

11-13-2003 12:13 AM in reply to: *Iwaskewycz, Brian R.
How do you get the spreadsheet function to update when inserting a custom

By way of explanation, I use custom iParts for standard materials such as
strut channel and 2X2 steel tube where you enter the length when you insert
the iPart. I then edit the part numbers for these parts to include the
length using iProperties. Since I would like to avoid having to edit the
part number each time I create a new part, spreadsheet functions seemed to
be an ideal solution.

So I set up a table for an iPart factory using Excel's text functions
(concatenate and some others) to create the correct part number, but when I
insert a custom iPart with this factory they always have the length as 36 in
the part number (36 is the default length of the iPart factory) rather than
the actual length of the custom iPart. And if I change the length, the part
number does not update. Either the function is not running when the custom
iPart is created or the part number function is not referencing the custom

Any suggestions on how I can get this to work?


*Stubbington, Scott
Message 12 of 14 (57 Views)


11-13-2003 05:40 PM in reply to: *Iwaskewycz, Brian R.
There are two places you can store VBA routines in Excel aren't there, one
being the workbook and the other being your personal.xls workbook... correct
me if I'm wrong. In the situation where VBA routines were corrupting the
IPart sheet, was the VBA routine stored in the workbook or the personal

Just curious

*Keller, Kent
Message 13 of 14 (57 Views)


11-14-2003 12:31 AM in reply to: *Iwaskewycz, Brian R.
Hi Scott

It has been a while, but as I remember it was in the "ThisWorkbook" that I placed the

Assistant Moderator
Autodesk Discussion Forum Moderator Program

"Scott Stubbington" wrote in message

In the situation where VBA routines were corrupting the
> IPart sheet, was the VBA routine stored in the workbook or the personal
> workbook?
> Just curious
> Scott
*Iwaskewycz, Brian R.
Message 14 of 14 (57 Views)


11-16-2003 09:48 PM in reply to: *Iwaskewycz, Brian R.
You could create any sort of function you want to generate the filename, but
it's not going to work with a custom iPart. As soon as you define a column
as a custom column (or a single cell as someone (Sean?) found), Inventor
ignores whatever is in the Filename column, and the user must manually
specify the filename and path.

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