Hi David, Well I got close, I think, the bom generated from Protel must not have the 'group' option _not_ clicked.
'Sort without formatting' would run without errors, but it only added a QTY column with the value of '1' in it for all the rows, ie no grouping. 'Sort Bom' although going further then before would still stop with the error 'Run-time error '9': Subscript out of range' at line 106 .. 'ReDim Preserve types_array(UBound(types_array) - 1)' UBound(types_array) with a value of 0 A step by step run through the process readme file would help. Regards, Darren Moore > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Hi all, > If you've ever pulled your hair out because you can't get a > sensible BOM > into Excel, for the purpose of ordering parts and assembling > PCBs, then I > may have the answer. I've written a single click BOM sorter > in Excel 2000 > VBA, to sort the 'CSV' or 'Client spreadsheet' BOMs into a > sensible format, > with all similar components on the same row. I'll attempt to > attach it > here, but it will probably be blocked. However, if you are > interested, > just send me an e-mail at: > [EMAIL PROTECTED] > > (See attached file: BOM sorter.xls) > > The code is unlocked, so you can play with it. Please note: > it doesn't run > under Excel97. > > Regards > > David Watling > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
