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 RSD Communications ltd Email [EMAIL PROTECTED] WWW http://www.rsd.tv ================================== > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, June 20, 2003 12:01 PM > To: [EMAIL PROTECTED] > Subject: [PEDA] BOM sorter > > > 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] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *