or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
26 used & new from £21.49

Have one to sell? Sell yours here
 
   
VBA Developer's Handbook
 
 

VBA Developer's Handbook (Paperback)

by Ken Getz (Author), Mike Gilbert (Author) "Almost any VBA application will need to handle string (text) data at one point or another ..." (more)
4.4 out of 5 stars  See all reviews (16 customer reviews)
RRP: £36.99
Price: £24.89 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £12.10 (33%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 5 left in stock--order soon (more on the way).

Want guaranteed delivery by Tuesday, November 17? Choose Express delivery at checkout. See Details
20 new from £22.66 6 used from £21.49

Frequently Bought Together

Customers buy this book with Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology) by Rob Bovey

VBA Developer's Handbook + Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)
Price For Both: £45.18

Show availability and delivery details


Customers Who Bought This Item Also Bought

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET: The Definitive Guide to ... and VBA (Addison-Wesley Microsoft Technology)

by Rob Bovey
4.9 out of 5 stars (19)  £20.29
Mastering Microsoft VBA

Mastering Microsoft VBA

by Guy HartDavis
3.7 out of 5 stars (3)  £15.89
VB & VBA in a Nutshell: The Language: The Languages (In a Nutshell (O'Reilly))

VB & VBA in a Nutshell: The Language: The Languages (In a Nutshell (O'Reilly))

by Paul Lomax
3.9 out of 5 stars (15)  £14.62
Access X Desktop Developer's Handbook (Professional Results)

Access X Desktop Developer's Handbook (Professional Results)

by Paul Litwin
£38.24
Absolute Beginner's Guide to VBA (Absolute Beginner's Guides)

Absolute Beginner's Guide to VBA (Absolute Beginner's Guides)

by Paul McFedries
3.8 out of 5 stars (4)  £6.97
Explore similar items

Product details

  • Paperback: 1104 pages
  • Publisher: John Wiley & Sons; 2nd Edition edition (14 May 2001)
  • Language English
  • ISBN-10: 0782129781
  • ISBN-13: 978-0782129786
  • Product Dimensions: 22.6 x 19.3 x 5.8 cm
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon.co.uk Sales Rank: 291,033 in Books (See Bestsellers in Books)
  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
   Access Developers opens new browser window
ApprovedDatabaseDevelopers.co.uk  -  Get free quotes from top UK MS Access Database Developers 
   VB Developer Courses opens new browser window
www.seeklearning.co.uk  -  Recommended VB Development courses to match your IT career. 
   Microsoft Dynamics-NAV opens new browser window
www.keensoft.co.uk  -  The value for money Dynamcs NAV solution provider 
  
 

Product Description

Product Description

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION

This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step–by–step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built–in VBA programmability.

Coverage Includes

  • Manipulating text, numbers, and dates
  • Using automation to control other applications
  • Creating objects using VBA class modules
  • Using standard search and sort algorithms from within VBA
  • Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues
  • Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status
  • Working with Windows Registry data
  • Retrieving and setting Windows networking information
  • Working with the Windows file system, iterating through folders, creating and deleting files
  • Adding sound and movies to VBA apps using Windows multimedia extensions
  • Tapping the system capabilities provided by the Windows Scripting Runtime library
  • Writing add–ins for the Visual Basic environment

Note: CD–ROM/DVD and other supplementary materials are not included as part of eBook file.



From the Back Cover

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION
This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step–by–step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built–in VBA programmability.

Coverage Includes
  • Manipulating text, numbers, and dates
  • Using automation to control other applications
  • Creating objects using VBA class modules
  • Using standard search and sort algorithms from within VBA
  • Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues
  • Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status
  • Working with Windows Registry data
  • Retrieving and setting Windows networking information
  • Working with the Windows file system, iterating through folders, creating and deleting files
  • Adding sound and movies to VBA apps using Windows multimedia extensions
  • Tapping the system capabilities provided by the Windows Scripting Runtime library
  • Writing add–ins for the Visual Basic environment

Inside This Book (Learn More)
First Sentence
Almost any VBA application will need to handle string (text) data at one point or another. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 


 

Customer Reviews

16 Reviews
5 star:
 (11)
4 star:
 (3)
3 star:
 (1)
2 star:    (0)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
4.4 out of 5 stars (16 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
34 of 34 people found the following review helpful:
5.0 out of 5 stars An excellent, worth every penny, book!, 13 May 1999
By A Customer
I have had this book for a long time and thought I should put in my .02 cents worth.

Please do not let some of the earlier reviews fool or confuse you. This is a VBA based book. What does that mean? First off it means that it covers the common programming language 'Visual Basic for Applications' (VBA) that is used by Microsoft Office as well as third party products like Visio, AutoCAD, etc. Second, 'the language' VBA is the same 'programming language' which is used by 'the product' Visual Basic 5.0/6.0 from Microsoft. Think of it this way: Microsoft Visual C++ is a Windows development tool that uses the language C++. Microsoft Excel is a spreadsheet tool that happens to contain a full blown programming language, VBA. In addition, Microsoft happens to sell a 'Windows development tool', called Visual Basic which in turn contains a full blow programming language, VBA. Except for some minor differences, the VBA in Office 97 is the 'same' as the version in the product Visual Basic 5.0.

This book does not pretend to be about 'the Visual Basic product' or any of the Microsoft Office products. It is about the 'common' programming language, VBA, which they (Visual Basic, Office, Visio, etc.) share! Some of the previous reviewers seem to be confused to these facts.

While the current edition of this book covers the version of VBA released with Office 97, all of the code would work in Visual Basic 5.0 or 6.0, Visio, AutoCAD, etc. In fact, with the release of VBA 6.0, the 'common programming language' will be the same in Visual Basic 6.0 and Office 2000 and soon to be released versions of Visio, etc.

This excellent book will NOT show you how to do database programming in Access, spreadsheet programming in Excel, or document programming in Word. It will NOT show you how to write ActiveX DLL's using the Visual Basic PRODUCT or do DCOM programming.

This book WILL however show you how to write great VBA code (remember, the language) you can use in any of the previously mentioned products. In addition, you will obtain code that will help you get system information, perform 'correct' date calculations, access the system registry, use multimedia features and more! Remember, if I'm wrong, you can send the book back. Nevertheless, if you want to get some understanding about the VBA 'language', get this book.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
9 of 10 people found the following review helpful:
4.0 out of 5 stars Cost, 5 Jun 2001
By A Customer
Why is this book (published 2001) a lot cheaper than the 1997 version. It contains the same, albeit, updated stuff. I agree with some of the other reveiws I have read - it's a disappointment in the way it deals with (or, rather, DOESN'T deal with) the interaction between itself and Excel and Word, which are the reasons we have VBA. Having said that, if you already know your way around Excel et al, and need a VBA book to enhance your already impressive skills, then this could be it. I liked it and will keep it by me for all future projects. Buy it, it's worth it
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
4 of 4 people found the following review helpful:
5.0 out of 5 stars MSI Creation Reference, 19 Jan 2004
By Mr. Gm Ashby (United Kingdom) - See all my reviews
(REAL NAME)   
Simply put - "The Daddy" for use as an MSI packager's reference guide to creating , editing or troubleshooting MSI packages. Whenever I need to look something up beyond the Help files of my MSI authoring tool , or need to resolve an ORCA ICE error, this book is my first and usually last port of call.

It would have taken me an awful lot longer to get to grips with the MSI technology without this book. No hesitation in reccommending it to novice and expert MSI packagers alike.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Complex, comprehensive and invaluable
This book is not a simple "how to make wizzy buttons in Excel" book. It treats VBA as a language in its own right with functions, classes, syntax etc. Read more
Published on 6 Jul 2005 by blanchas2

5.0 out of 5 stars VBA Handbook
A very good book - excellent and very usefull code examples. For example (Monday morning) I need a vba function to calculate someones age. Read more
Published on 16 Sep 2003 by D. PIKE

5.0 out of 5 stars Not a VBA Book
The book is definitely a treasure and will set on my desk a long time; ready for referal. But it is more of a VB book than anything else. Read more
Published on 12 May 1999

5.0 out of 5 stars If you're a VBA developer, you need this book!
I couldn't believe how much useful, reusable code I found in this book. I also don't understand the complaints people have about this book not being about VBA. Read more
Published on 3 Feb 1999

1.0 out of 5 stars VBA? Book should be titled "VB with additional VBA insights"
I expected great detail using VBA with both Excel and Word. What a disappointment! This book discussed items like dealing with the registry, sort routines, etc. Read more
Published on 24 Dec 1998

5.0 out of 5 stars Authoritative, expertly written, almost biblical !
After perusing this text in the bookstore, I knew that I had to have it. Great text! It is exactly what it says...VBA Developer's Handbook. Read more
Published on 8 Dec 1998

4.0 out of 5 stars Good handbook and reference for VB code
As mentioned by another reviewer, this book is concerned less with the VBA behind office, than with writing general visual basic code. Read more
Published on 29 Oct 1998

5.0 out of 5 stars Useful tool
I found this book to be just as useful for VB as I did for VBA. The ussue's discused are not as easy to find in competing texts. Read more
Published on 22 Oct 1998

3.0 out of 5 stars A dissenting opinion
On p. 418 of this book occurs the following statement: "One of VBA's greatest strengths is its ability to control other applications using Automation. Read more
Published on 6 Jul 1998

5.0 out of 5 stars Well written, well documented, exceptionally thorough!
This is a must have book for anyone who wants to move past the beginner of level of VBA (and / or VB in general). Read more
Published on 4 Jun 1998

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

   


Listmania!


Look for similar items by category


Look for similar items by subject


Feedback

Ad

Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.