NYCPHP Meetup

[Freedman, Tom S.]

I hate to be this way, but your friend must be doing something wrong.  I
just did a mockup in Excel 97 (we're still in the dark ages here) and it
worked fine going from string to number.

If you're going to go the VBA route, there is a "Switch Case" construct,
instead of using a bunch of if-elses.

-----Original Message-----
From: soazine at pop.erols.com [mailto:soazine at pop.mail.rcn.net]
Sent: Wednesday, April 02, 2003 2:25 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Anyone out there know how to write MS Excel
2000 VB Macros?


Thanx, however, my friend is having problems with the VLOOKUP insofar as
that it will convert from number to string but not from string to number.

I am not sure how to help him rather than writing a super-complex IF
statement.

Phil

Original Message:
-----------------
From: Christopher R. Merlo cmerlo at turing.matcmp.ncc.edu
Date: Wed,  2 Apr 2003 13:36:01 -0500
To: talk at nyphp.org
Subject: Re: [nycphp-talk] Anyone out there know how to write MS Excel 2000
VB Macros?


Oh, BTW, I should mention that I did that stuff in Gnumeric, not
Excel, so my apologies if the order of parameters is different.  Tell
your friend just to look up Excel's vlookup function -- it's real
similar, if not exactly the same.

-- 
cmerlo at turing.matcmp.ncc.edu        http://turing.matcmp.ncc.edu/~cmerlo

Windows:  More than enough rope.






--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .





--- Unsubscribe at http://nyphp.org/list/ ---