I haven't found a way, but IF you could hide a column's border line, you
could create a column that contained the values for 2 parmeters.
That would allow you to have a text parameter for your SSP-001-L and then a
driven numerical parameter for your length.......
Then you'd have to merge 2 cells for the title, of course.
Am I dreaming? 🙂
--
______________
Rui
www.cadmais.pt
"Michael Trull" wrote in message
news:8C9A965358AD969DA7F67135C9880607@in.WebX.maYIadrTaRb...
> Charles:
>
> Without question filename management after the initial save is a problem.
> But the key piece of information driving a machine build is the part
number
> and automatically updating it to reflect the correct length would mean
that
> I would always have a correct bill of materials.
>
> As it is now, I have to manually update the part number so the bill of
> materials is always at risk of being in error due to my negligence. To try
> to minimize human error, I use a dummy part number (SSP-001-LXX.XXX for
> example) and do not edit it until I am ready to release the bill of
> materials. By doing this I know the part number is wrong by just looking
at
> it. If I did not do this, a 36" part could slip by with a 24" part number.
>
> Regarding filenames, it is convenient to be able to quickly recognize
parts
> by making the filename be the part number, but this has no effect on the
> bill of materials or the build. At the end of a project I typically use
the
> Design Assistant to update the filenames to be the part number, but this
is
> not necessary. I could just leave Inventor's default filenames (Part 1,
Part
> 2, Part 3, etc.) and everything would be fine as long as the part numbers
> are correct.
>
> Considering that I only edit a fraction of the custom iparts created for a
> project after their initial creation, using the part number as the initial
> filename would save some time in the Design Assistant since the filenames
> would be correct for all the parts that were not edited. As it is now, I
> must edit every custom iPart (and its part number).
>
> By the way, I use your bill of material extractor to generate the bill of
> materials for each project and consider it to be the most valuable add-on
I
> have ever run across for Inventor. It not only provides a list of parts,
in
> Excel format, which can be used to manage purchasing and part fabrication,
> but it also becomes the specification driving the fabrication of a large
> number of our parts eliminating the need for detail drawings (because of
the
> way we structure our part numbers). For example, I can provide a
structural
> steel cut list to the shop by just printing out all of the SSP-001-L??.???
> entries. Autodesk would be well advised to add this type of BOM reporting
> capability to inventor's Design Assistant.
>
> I apologize for the length of this message - I truly appreciate your
> observations and assistance.
>
> Sincerely,
>
> Michael
>
>
> "Charles Bliss" wrote in message
> news:7C298285388FA8F8F32B9E216B4EBF46@in.WebX.maYIadrTaRb...
> > So, you want the file's macro to trap the OnSave event and check the
> > filename against the length parameter. If the length has changed, you
> > want to rename and relink the file. What happens to other "were used"
> > assemblies?
>
>