Hi Kent & Frank,
Here it is Monday and I find two extremely over committed people working on
the weekend "Whats up with that?" ;~)
After reading your thread and thinking about your problem I started thinking
about my program for partlist standardization and thought I might ask as
well as share.
Kent, would it work to just redefine the BOM and not try to build a circle
out of a square? For my BOM/Partlist stuff I redefined what the
BOM/Partlist looked like by using a template drawing and creating my own
Symbol standard. This works great for imposing your own standard on a
part/assy. If you look through the symbol standards there is a spot in
there to redefine it and apply a custom scheme.
Kent Keller wrote in message <
[email protected]>...
>Well I am ashamed to say that somewhere along the way I must have
>started re writing the code under
>
>On Error Resume Next
>
>when it used to be above it.
>
>If I remove that then this hangs also. I am about ready to
>totally give up on writing anything with the Mcad stuff. I can
>never tell if it is my Newbe - ness, or the poor documentation(so
>if I keep working I will eventually end up with something that
>works, or that it just plain doesn't work at all.
>
>Frustrated......
>
>
> For Each column In BOMstd.columns
> Debug.Print column.Name
> If column.Name <> "ITEM" And column.Name <> "DET" And
>column.Name <> "QTY" And column.Name <> "SHEET" And _
> column.Name <> "NAME" And column.Name <> "DESCRIPTION" And
>column.Name <> "STK_SIZE" And column.Name <> "MATERIAL" And _
> column.Name <> "HT" And column.Name <> "NOTES" And
>column.Name <> "RELEASED" And column.Name <> "REVISED" Then
> BOMstd.columns.Remove column.Index
> End If
>Next
>
>--
>Kent Keller
>Check out the Mechanical Desktop FAQ @
>http://webhome.idirect.com/~dfulford/
>
>"Frank Oquendo"
wrote in message
>news:[email protected]...
>> So what does your final loop look like? Considering the dearth
>of MCAD info,
>> it sure would help to have a sample of working code. If you
>don't mind
>> sharing, of course.
>>
>> --
>> Visit me at: http://www2.stonemedia.com/franko
>>
>>
>> "Kent Keller" wrote in message
>> news:[email protected]...
>> > Frank
>> >
>> > I found this method and it seems to work fine now.
>> >
>> > BOMstd.columns.Remove column.Index
>> > Why we have this method and the other beats me. It was really
>odd
>> > with the other line in there. It would stop on the line shown
>> > below one time and then if you exited and ran it again it
>would go
>> > thru a few times and then stop on the line after that one.
>> >
>> > Now I am trying to figure out how to add all the columns I
>want.
>> > This crazy thing lets you add duplicates, without a error
>message,
>> > but when you then manually go into the symstd you have a mess,
>> > that you sometimes can't clean up because there are certain
>> > columns you can't delete, but yet you have duplicates so it
>> > complains. I was hoping to just use a on error resume next
>but
>> > ........ I guess not.
>> >
>> > Everything in the Mcad stuff seems twice as hard. I sure
>hope
>> > they are improving the code along with the help files for the
>next
>> > go.
>> >
>> > --
>> > Kent Keller
>> > Check out the Mechanical Desktop FAQ @
>> > http://webhome.idirect.com/~dfulford/
>> >
>> > "Kent Keller" wrote in message
>> > news:[email protected]...
>> > > Closer
>> > >
>> > > It looked like it was working and then it stopped on the
>line
>> > >
>> > > If column.Name <> "ITEM" And column.Name <> "QTY" And
>> > column.Name
>> > > <> "NAME" Then
>> > >
>> > > Saying "Method "Name" of object "IMcadColumnDefinition"
>> > failed.
>> > >
>> > > I will play with it a little and see if I can figure out
>what
>> > went
>> > > wrong.
>> > >
>> > > --
>> > > Kent Keller
>> > > Check out the Mechanical Desktop FAQ @
>> > > http://webhome.idirect.com/~dfulford/
>> > >
>> > > "Frank Oquendo" wrote in
>message
>> > > news:[email protected]...
>> > > > Then how about this:
>> > > >
>> > > > For Each column In BOMstd.Columns
>> > > > If column.Name <> "ITEM" And column.Name <> "QTY" And
>> > > column.Name <>
>> > > > "NAME" Then
>> > > > BOMstd.RemoveColumn column.index
>> > > > End If
>> > > > Next
>> > > >
>> > > > --
>> > > > Visit me at: http://www2.stonemedia.com/franko
>> > > >
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>