Inventor General Discussion

Inventor General Discussion

Reply
*Trull, Michael
Message 11 of 14 (76 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
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
*Stubbington, Scott
Message 12 of 14 (76 Views)

Re:

11-13-2003 05:40 PM in reply to: *Iwaskewycz, Brian R.
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
*Keller, Kent
Message 13 of 14 (76 Views)

Re:

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
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
>
>
*Iwaskewycz, Brian R.
Message 14 of 14 (76 Views)

Re:

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