Coverart for item
The Resource Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA, Stephen Bullen, Rob Bovey, John Green

Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA, Stephen Bullen, Rob Bovey, John Green

Label
Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA
Title
Professional Excel development
Title remainder
the definitive guide to developing applications using Microsoft Excel and VBA
Statement of responsibility
Stephen Bullen, Rob Bovey, John Green
Title variation
  • Professional Excel development the definitive guide to developing applications using Microsoft Excel and VBA
  • Definitive guide to developing applications using Microsoft Excel and VBA
Creator
Contributor
Subject
Genre
Language
eng
Summary
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies-including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes Building add-ins to provide new Excel functions Designing effective worksheets, userforms and other user interface elements Leveraging Excel's powerful data analysis features Creating sophisticated custom charts Handling errors, debugging applications and optimizing performance Using class modules and interfaces to create custom objects Understanding Windows API calls: when to use them, and how to modify them Adding worksheet functions with C-based XLLs Programming with databases Controlling external applications from Excel Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office Using XML to import and export data and communicate with Web services Providing help, securing, packaging and distributing The accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities. © Copyright Pearson Education. All rights reserved
Member of
Cataloging source
EYR
http://library.link/vocab/creatorName
Bullen, Stephen
Dewey number
005.54
Illustrations
illustrations
Index
index present
LC call number
HF5548.4.M523
LC item number
.B866 2005eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorDate
1945-
http://library.link/vocab/relatedWorkOrContributorName
  • Bovey, Rob
  • Green, John
Target audience
specialized
Label
Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA, Stephen Bullen, Rob Bovey, John Green
Instantiates
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
  • multicolored
  • black and white
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • Ch. 5.
  • Function, general and application-specific add-ins
  • Ch. 6.
  • Dictator applications
  • Ch. 7.
  • Using class modules to create objects
  • Ch. 8.
  • Advanced command bar handling
  • Ch. 9.
  • Understanding and using Windows API calls
  • Ch. 1.
  • Ch. 10.
  • Userform design and best practices
  • Ch. 11.
  • Interfaces
  • Ch. 12.
  • VBA error handling
  • Ch. 13.
  • Programming with databases
  • Ch. 14.
  • Data manipulation techniques
  • Introduction
  • Ch. 15.
  • Advanced charting techniques
  • Ch. 16.
  • VBA debugging
  • Ch. 17.
  • Optimizing VBA performance
  • Ch. 18.
  • Controlling other Office applications
  • Ch. 19.
  • XLLs and the C API
  • Ch. 2.
  • Ch. 20.
  • Combining Excel and Visual Basic 6
  • Ch. 21.
  • Writing add-ins with Visual Basic 6
  • Ch. 22.
  • Using VB.NET and the Visual studio tools for Office
  • Ch. 23.
  • Excel, XML and Web services
  • Ch. 24.
  • Providing help, securing, packaging and distributing
  • Application architectures
  • Ch. 3.
  • Excel and VBA development best practices
  • Ch. 4.
  • Worksheet design
Control code
59169631
Dimensions
unknown
Extent
1 online resource (xvii, 913 pages)
File format
unknown
Form of item
online
Isbn
9780321262509
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
Quality assurance targets
not applicable
Reformatting quality
unknown
Specific material designation
remote
System control number
(OCoLC)59169631
Label
Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA, Stephen Bullen, Rob Bovey, John Green
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
  • multicolored
  • black and white
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • Ch. 5.
  • Function, general and application-specific add-ins
  • Ch. 6.
  • Dictator applications
  • Ch. 7.
  • Using class modules to create objects
  • Ch. 8.
  • Advanced command bar handling
  • Ch. 9.
  • Understanding and using Windows API calls
  • Ch. 1.
  • Ch. 10.
  • Userform design and best practices
  • Ch. 11.
  • Interfaces
  • Ch. 12.
  • VBA error handling
  • Ch. 13.
  • Programming with databases
  • Ch. 14.
  • Data manipulation techniques
  • Introduction
  • Ch. 15.
  • Advanced charting techniques
  • Ch. 16.
  • VBA debugging
  • Ch. 17.
  • Optimizing VBA performance
  • Ch. 18.
  • Controlling other Office applications
  • Ch. 19.
  • XLLs and the C API
  • Ch. 2.
  • Ch. 20.
  • Combining Excel and Visual Basic 6
  • Ch. 21.
  • Writing add-ins with Visual Basic 6
  • Ch. 22.
  • Using VB.NET and the Visual studio tools for Office
  • Ch. 23.
  • Excel, XML and Web services
  • Ch. 24.
  • Providing help, securing, packaging and distributing
  • Application architectures
  • Ch. 3.
  • Excel and VBA development best practices
  • Ch. 4.
  • Worksheet design
Control code
59169631
Dimensions
unknown
Extent
1 online resource (xvii, 913 pages)
File format
unknown
Form of item
online
Isbn
9780321262509
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
Quality assurance targets
not applicable
Reformatting quality
unknown
Specific material designation
remote
System control number
(OCoLC)59169631

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...