AnyBook4Less.com | Order from a Major Online Bookstore |
![]() |
Home |  Store List |  FAQ |  Contact Us |   | ||
Ultimate Book Price Comparison Engine Save Your Time And Money |
![]() |
Title: Definitive Guide to Excel VBA, Second Edition by Michael Kofler ISBN: 1-59059-103-8 Publisher: APress Pub. Date: 16 July, 2003 Format: Paperback Volumes: 1 List Price(USD): $54.99 |
Average Customer Rating: 4.14 (14 reviews)
Rating: 4
Summary: An Afterthought
Comment: After looking through virtually every other book on VBA, only Kofler's book discusses the clipboard and clearly states the severe limitations of VBA in accessing it.
On pp. 208-211 Kofler describes the use of the clipboard from VBA. He points out that only the last item added to the clipboard is accessible, and how to do it. Later, pp. 762-765, Kofler introduces the programming of a new ActiveX server with VB that is used from within Excel. This approach extends clipboard access for large data sets, and requires setup using some executable VB subroutines on the supplied disk.
It's surprising that other books don't discuss such an important topic, even though Microsoft has made more than limited access to this feature unbearable.
I stick with my four-star rating.
Rating: 5
Summary: One of the definitive guides to Excel VBA books
Comment: I won't say this book is "the only Excel VBA book you will need" -- there is no such kind of thing for programming books. However, I like to say it is one of the best and definitive guides to Excel VBA. The most important thing is that there are several advanced topics you won't find on the other popular Excel VBA books (such as Excel 2002 VBA programminer's Reference by Stephen Bullen, John Green et al. or Excel 2002 Power Programming with VBA by John Walkenback): for instance, recursion, details of random numbers generation, matrix functions, automatic data reporting, OLAP functionality and using Excel as ActiveX server. However, I also must say this book is definitely not for the beginners to learn VBA.
Rating: 5
Summary: Excellent
Comment: This is an excellent guide to Excel VBA. I have programmed in VB for 12+ years, but have barely dabbled in VBA. I needed to develop some tools for Excel using VBA. I asked expert friends on Experts-Exchange (www.experts-exchange.com) and Open IT (pub21.ezboard.com/bopenitforum) and they gave me three highly recommended books. I look on Amazon and came up with about five to consider, include those three previously recommended. I looked at copies of those and others and chose this book as the one most likely to fit my needs. So far, I am not disappointed.
![]() |
Title: Excel 2002 Power Programming with VBA by John Walkenbach ISBN: 0764547992 Publisher: John Wiley & Sons Pub. Date: 01 July, 2001 List Price(USD): $49.99 |
![]() |
Title: Excel 2002 VBA: Programmers Reference by Rob Bovey, Stephen Bullen, John Green, Robert Rosenberg ISBN: 0764543717 Publisher: Wrox Pub. Date: 26 September, 2001 List Price(USD): $39.99 |
![]() |
Title: Excel Programming: Your Visual Blueprint for Creating Interactive Spreadsheets (With CD-ROM) by Jinjer Simon ISBN: 076453646X Publisher: Visual Pub. Date: 15 November, 2001 List Price(USD): $26.99 |
![]() |
Title: Microsoft Excel 2002 Visual Basic for Applications Step by Step by Reed Jacobson ISBN: 0735613591 Publisher: Microsoft Press Pub. Date: 12 September, 2001 List Price(USD): $39.99 |
![]() |
Title: Writing Excel Macros with VBA, 2nd Edition by Steven Roman ISBN: 0596003595 Publisher: O'Reilly & Associates Pub. Date: 15 June, 2002 List Price(USD): $34.95 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments