NYCPHP Meetup

[nycphp-talk] Anyone out there know how to write MS Excel 2000 VB Macros?

Freedman, Tom S. tfreedma at ubspw.com
Wed Apr 2 15:08:50 EST 2003


Replying off list...

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


Could you either give me an example of how to use VLOOKUP to convert from
number to string, or could you show me the steps toward writing simple VBA
to be used within Excel 2000 (I don't have the O'Reilly book on me I'm
afraid).

Thanx
Phil

Original Message:
-----------------
From: Freedman, Tom S. tfreedma at ubspw.com
Date: Wed,  2 Apr 2003 14:40:42 -0500
To: talk at nyphp.org
Subject: RE: [nycphp-talk] Anyone out there know how to write MS Excel 2000
VB Macros?


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/ .













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





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




More information about the talk mailing list