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