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)
--
Thanks,

Galen

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-...0-04643-2-316/

and Google books has portions available online:
http://books.google.com/books?id=r18Oma_vbaMC&dq=Excel+2007+VBA+Programmer 's+Reference&printsec=frontcover&source=bn&hl=en&e i=56ySSqvBNcbQlAftnPxg&sa=X&oi=book_result&ct=resu lt&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.

--
__________________________________
HTH

Bob

"Galen" wrote in message
...
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)
--
Thanks,

Galen

thanks for the recc
--
Thanks,

Galen


"arjen van der wal" wrote:


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-...0-04643-2-316/

and Google books has portions available online:
http://books.google.com/books?id=r18Oma_vbaMC&dq=Excel+2007+VBA+Programmer 's+Reference&printsec=frontcover&source=bn&hl=en&e i=56ySSqvBNcbQlAftnPxg&sa=X&oi=book_result&ct=resu lt&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.

thank you
--
Thanks,

Galen


"Bob Phillips" wrote:

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.

--
__________________________________
HTH

Bob

"Galen" wrote in message
...
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)
--
Thanks,

Galen

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)


On Mon, 24 Aug 2009 16:19:13 +0100, "Bob Phillips"
wrote:

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.