VBA book

[Galen]

I am new to VBA can anyone reccomend a good book for getting started and what
the backwards compatibility is like for macros in excel 2007 if not everyone
i work with has the same version of excel?

this is the book i am thinking about getting

Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) by John
Walkenbach (Paperback - April 16, 2007)

 

[arjen van der wal]

A book that I've found very useful is Excel 2007 VBA Programmer's
Reference (Wrox) by John Green, Stephen Bullen, Rob Bovey & Michael
Alexander. If you want to see what it's like you can downlod a sample chapter
from the Wrox website
http://p2p.wrox.com/book-excel-2007-vba-programmers-reference-isbn-978-0-470-04643-2-316/

and Google books has portions available online
http://books.google.com/books?id=r1...esult&ct=result&resnum=4#v=onepage&q=&f=false

I'd say compared to the Walkenbach book you mentioned, it's probably more
intensive. There's a lot of programming basics covered in Chapter 1, whereas
the Walkenbach book takes a few chapters to get into the programming, giving
more background. Just my thoughts.

 

[Bob Phillips]

That's a good book, certainly a frequent entry in recommended books.

The backward compatibility is not a thing to worry greatly about, VBA hasn't
changed much, just make sure that you either develop on the previous
versions or test with it.

 

[Galen]

thanks for the recc

 

[Galen]

thank you
--
Thanks,

Galen

That's a good book, certainly a frequent entry in recommended books.

The backward compatibility is not a thing to worry greatly about, VBA hasn't
changed much, just make sure that you either develop on the previous
versions or test with it.

 

[Chip Pearson]

VBA hasn't changed much,

I would amend that statement to "VBA hasn't change at all". I can't
think of anything new in VBA since VBA6 in 2000. Excel, of course, has
changed, but VBA hasn't been updated in a decade (other than the port
to 64 bit), and probably never will be updated.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)