Hi again Brad & all,
Try running it on a 'Client spreadsheet' BOM.  It will definitely not work
on a Protel BOM.
It was looping until Part Type was empty, so if any Part types were empty,
it stopped there.  I have corrected this, so it now checks the first two
I don't know what this run time error 13 is - could someone send me a BOM
which displays this error?
I will write a read.me file soon, as I seem to be getting some interest.  I
now know how the guys at Protel feel when users start reporting bugs!

(See attached file: BOM sorter.xls)


David Watling

                      Brad Velander                                                    
                      <[EMAIL PROTECTED]        To:       Protel EDA Forum <[EMAIL 
                      .com>                    cc:                                     
                                               Subject:  Re: [PEDA] BOM sorter         
                      20-Jun-2003 09:23                                                
                      Please respond to                                                
                      Protel EDA Forum                                                 

Well I got the macros to be recognized, had to change the macro security
level. Now I have it adding a "Qty" header and it seems to format the
column widths but nothing else happens.

             To Dave Watling,
             Dave, I think that your excel wooksheet needs at least a small
readme file. It is not as simple as one might think it could be. Can you
give us the BOM format, number of columns, headers or no headers, anything
else that we might not inherently know.

             While playing, it did combine two designators onto one line
but listed the quantity still as "1". That is as far it would go, just one
line and it was in error because it should have had a quantity of 2. It
also doesn't seem to handle rows where the first column is blank. And I
have now seen the runtime error 13 a number of times as well.

Brad Velander.

Lead PCB Designer
Norsat International Inc.
Microwave Products
Tel   (604) 292-9089 (direct line)
Fax  (604) 292-9010

CONFIDENTIALITY: This e-mail and any attached files may contain information
that is confidential and may be privileged.
If you are not the intended recipient or the person responsible for
delivering the message to the intended recipient,  please
notify the sender immediately and do not disclose the contents to another
person, use it for any purpose or store or copy
the information in any medium.  Thank you.

> -----Original Message-----
> From: John A. Ross [Design] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 2003 9:09 AM
> To: Protel EDA Forum
> Subject: Re: [PEDA] BOM sorter
> Dave
> All I get out of it is run time error 13 type mismatch.
> Is the procedure just open file, load csv and go?
> Best Regards
> John A. Ross

Attachment: BOM sorter.xls
Description: application/msexcel

Reply via email to