VBA book

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

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

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

Galen

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top