VBA book

  • Thread starter Thread starter Galen
  • Start date Start date
G

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)
 
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.
 
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.
 
thank you
--
Thanks,

Galen


Bob Phillips said:
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.
Click to expand...
 
VBA hasn't changed much,
Click to expand...

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)
 
Back
Top