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 columns. 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) Regards David Watling Brad Velander <[EMAIL PROTECTED] To: Protel EDA Forum <[EMAIL PROTECTED]> .com> cc: Subject: Re: [PEDA] BOM sorter 20-Jun-2003 09:23 PM 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. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com 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