Autodesk Inventor

[#1]

How do you get the spreadsheet function to update when inserting a custom
iPart?

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
length.

Any suggestions on how I can get this to work?

Sincerely,

Michael

[#2]

Hello,
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
workbook?

Just curious

Scott

[#3]

Hi Scott

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

--
Kent
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
>
>

[#4]

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.