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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Reply via email to