VBA REFERENCE BOOK SUGGESTIONS

[Alex]

Looking for a reference book for VBA.

I have the Excel 2000 VBA by WROX.. it's ok. I''ve found I like O'reily
books better on the reference side and was wondering if they made one or if
there was something just as good along those lines.

Something that gives good examples in variations of objects / methods /
property uses.

 

[Tom Ogilvy]

Only OReilly book I can think of is Writing Excel Macros 2nd Ed by Steve
Roman.

You might check out John Walkenbach's Excel xxxx Power Programming with VBA.
See John's site at http://www.j-walk.com/ss/excel he has a link to pages on
his books from there.

That said, the Wrox book pretty much covers the topic.

 

[Bob Phillips]

Alex,

Have to say that I find that better than OK, it's the best Excel VBA book
IMO. It's object model section makes it useful for a long time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Sean McPoland]

Best book I have seen by far is Mastering Excel 2003
(Programming with VBA) by Steven M Hansen

Published by SYBEX 2004
ISBN No is 0-7821-4281-8
Library of Congress No is 2003115586

It is up to date and full of excellent articles and much
can be used backwards to lower levels of Excel

regards
Sean

 

[Tom Ogilvy]

If you have the time to elborate, what books are you comparing it to and
what experience do you have with those books?