VBA Reference Book?

[Guest]

I'm happily using Excel 97 and see no compelling reason to upgrade it.
For some time I've been creating a few VBA functions just from kind of
hacking at it and using my knowledge of Basic from 25 years ago and
Excel's help file and some persistence. The time has come to break down
and buy a book though.

Toward that end I have two questions:

1) What VBA reference book do you folks find most useful? With listings
of all the VBA commands, some examples, etc.

2) Most of the books available today are based on VBA for Excel 2003 of
course. Is that significantly different from 97, or has VBA just been
embroidered around the edges a bit since 97? I'm presuming it's pretty
much unchanged.

Thanks....

Bill

 

[Bob Phillips]

Bill,

One of 3 books I would suggest

VBA For Dummies by John Walkenbach,
Power Programming With VBA by JW (again)
Excel VBA Programmer's Reference by John Green, Stephen Bullen & Rob Bovey
et al.

All of these will have been edited for later Excel releases, so if you
search eBay, you should be able to get an older version, and cheap.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Harald Staff]

Hi Bill

Nothing is changed or removed since version 97. New stuff is just added and
extended.

Office for Windows went from VB5 to VB6 as VBA language with version 2000.
If you're into programming then I recommend an upgrade.

Second Bob's list of books.

HTH. Best wishes Harald

 

[Bob Phillips]

If you're into programming then I recommend an upgrade.

And I second that statement

 

[Guest]

And I second that statement

I understand what you're saying, but... While I've done a lot of
programming over the years, it's become just a necessary evil to me now.
Not the interesting challenge it used to be. I haven't stumbled on
anything Excel 97 won't do that I want, so I just keep using it.

Thanks...

Bill

 

[Dave Peterson]

I bet Bob and Harald both would recommend keeping xl97 on your pc (after the
upgrade) if you support users who are still at xl97.

In fact, if you're supporting multiple versions, you may want to develop in the
earliest.