VBA Reference Book?

G

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
 
H

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
 
G

Guest

Bob said:
And I second that statement :)
Click to expand...

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
 
D

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