Good Excel VBA book???

[Guest]

Hi guys,

I am looking for a good Excel VBA book to learn how to code things like
comparing 2 spreadsheets from 2 different workbbooks and matching cells from
1 column from each, updating rows and inserting rows for new items.

I am pretty confident coding Access VBA and some VB, but I want to learn
more about Excel VBA terminology and such.

 

[Guest]

Have a look at Exceltips.com. They advertise a good ebook on macros

 

[Dave Peterson]

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with. I think that John Green (and
others) is nice, too (for a second book??). See if you can find them in your
local bookstore and you can choose what one you like best.

 

[Guest]

Anything by John WalkenBach... He is Yoda of the Excel world..

The VBA help is actually really good (finally) too.

 

[leaftye - ExcelForums.com]

I downloaded almost all the books out there in PDF format, and I ended
up buying Excel 2003 Power Programming with VBA.

 

[Guest]

Don't forget using the macro recorder to record some code is also a good
resource to learn how things are referenced. Just remember the recorder will
want to "select" everything whereas when you write your own code you don't
need (and generally don't want) to select things to work with them.

I have Walkenbach's Excel 2000 VBA and would recommend it. The format is
easier to follow than some other VBA programming books I've run across, but
no less informative.