skip to content
Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA Preview this item
ClosePreview this item
Checking...

Professional Excel development : the definitive guide to developing applications using Microsoft Excel and VBA

Author: Stephen Bullen; Rob Bovey; John Green
Publisher: Upper Saddle River, NJ ; Munich [u.a.] : Addison-Wesley, 2005.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Publication:Professional Excel development.
Summary:

Written for professional developers and Excel experts, this book demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform  Read more...

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Stephen Bullen; Rob Bovey; John Green
ISBN: 0321262506 9780321262509
OCLC Number: 316288906
In: Bullen, Stephen
Notes: Dateiformat Volltext: HTML. Produktionsjahr der Online-Ausg.: 2005.
Description: 1 online resource (Online-Ressource.).
Contents: ContentsAcknowledgments.About the Authors.1. Introduction. About This Book The Excel Developer Excel as an Application Development Platform Structure Examples Supported Versions Typefaces On the CD Help and Support Feedback 2. Application Architectures. Concepts Conclusion 3. Excel and VBA Development Best Practices. Naming Conventions Best Practices for Application Structure and Organization General Application Development Best Practices Conclusion 4. Worksheet Design. Principles of Good Worksheet UI Design Program Rows and Columns: The Fundamental UI Design Technique Defined Names Styles User Interface Drawing Techniques Data Validation Conditional Formatting Using Controls on Worksheets Practical Example Conclusion 5. Function, General and Application-Specific Add-ins. The Four Stages of an Application Function Library Add-ins General Add-ins Application-Specific Add-ins Practical Example Conclusion 6. Dictator Applications. Structure of a Dictator Application Practical Example Conclusion 7. Using Class Modules to Create Objects. Creating Objects Creating a Collection Trapping Events Raising Events Practical Example Conclusion 8. Advanced Command Bar Handling. Command Bar Design Table-Driven Command Bars Putting It All Together Loading Custom Icons from Files Hooking Command Bar Control Events Practical Example Conclusion 9. Understanding and Using Windows API Calls. Overview Working with the Screen Working with Windows Working with the Keyboard Working with the File System and Network Practical Examples Conclusion 10. Userform Design and Best Practices. Principles Control Fundamentals Visual Effects Userform Positioning and Sizing Wizards Dynamic Userforms Modeless Userforms Control Specifics Practical Examples Conclusion 11. Interfaces. What Is an Interface? Code Reuse Defining a Custom Interface Implementing a Custom Interface Using a Custom Interface Polymorphic Classes Improving Robustness Simplifying Development A Plug-in Architecture Practical Example Conclusion 12. VBA Error Handling. Error-Handling Concepts The Single Exit Point Principle Simple Error Handling Complex Project Error Handler Organization The Central Error Handler Error Handling in Classes and Userforms Putting It All Together Practical Example Conclusion 13. Programming with Databases. An Introduction to Databases Designing the Data Access Tier Data Access with SQL and ADO Further Reading Practical Example Conclusion 14. Data Manipulation Techniques. Excel's Data Structures Data Processing Features Advanced Functions Conclusion 15. Advanced Charting Techniques. Fundamental Techniques VBA Techniques Conclusion 16. VBA Debugging. Basic VBA Debugging Techniques The Immediate Window (Ctrl+G) The Call Stack (Ctrl+L) The Watch Window The Locals Window The Object Browser (F2) Creating and Running a Test Harness Using Assertions Debugging Shortcut Keys that Every Developer Should Know Conclusion 17. Optimizing VBA Performance. Measuring Performance The PerfMon Utility Creative Thinking Macro-Optimization Micro-Optimization Conclusion 18. Controlling Other Office Applications. Fundamentals The Primary Office Application Object Models Practical Example Conclusion 19. XLLs and the C API. Why Create an XLL-Based Worksheet Function Creating an XLL Project in Visual Studio The Structure of an XLL The XLOPER and OPER Data Types The Excel4 Function Commonly Used C API Functions XLOPERs and Memory Management Registering and Unregistering Custom Worksheet Functions Sample Application Function Debugging the Worksheet Functions Miscellaneous Topics Additional Resources Conclusion 20. Combining Excel and Visual Basic 6. A Hello World ActiveX DLL Why Use VB6 ActiveX DLLs in Excel VBA Projects In-Process versus Out-of-Process Automating Excel From a VB6 EXE Practical Examples Conclusion 21. Writing Add-ins with Visual Basic 6. A Hello World Add-in The Add-in Designer Installation Considerations The AddinInstance Events Command Bar Handling Why Use a COM Add-in? Automation Add-ins Practical Example Conclusion 22. Using VB.NET and the Visual Studio Tools for Office. Overview How to Leverage the .NET Framework Managed Workbooks Managed Excel Add-ins Hybrid VBA/VSTO Solutions The VSTO Security Model The Big Issues Further Reading Practical Example Conclusion 23. Excel, XML and Web Services. XML Web Services Practical Example Conclusion 24. Providing Help, Securing, Packaging and Distributing. Providing Help Securing Packaging Distributing Conclusion Index.
Responsibility: Stephen Bullen; Rob Bovey; John Green.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/316288906> # Professional Excel development the definitive guide to developing applications using Microsoft Excel and VBA
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "316288906" ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/794329374#Place/munich_u_a> ; # Munich u.a.
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/794329374#Place/upper_saddle_river_nj> ; # Upper Saddle River, NJ
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/nju> ;
    schema:about <http://id.worldcat.org/fast/1382545> ; # Microsoft Visual Basic for applications.
    schema:about <http://id.worldcat.org/fast/1366659> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/794329374#CreativeWork/microsoft_excel_computer_file> ; # Microsoft Excel (Computer file)
    schema:about <http://experiment.worldcat.org/entity/work/data/794329374#CreativeWork/microsoft_visual_basic_for_applications> ; # Microsoft Visual Basic for applications.
    schema:bookFormat schema:EBook ;
    schema:contributor <http://viaf.org/viaf/68283039> ; # Stephen Bullen
    schema:contributor <http://experiment.worldcat.org/entity/work/data/794329374#Person/green_john> ; # John Green
    schema:contributor <http://viaf.org/viaf/31509948> ; # Rob Bovey
    schema:datePublished "2005" ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/794329374> ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/794329374#CreativeWork/> ;
    schema:name "Professional Excel development the definitive guide to developing applications using Microsoft Excel and VBA" ;
    schema:productID "316288906" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/316288906#PublicationEvent/upper_saddle_river_nj_munich_u_a_addison_wesley_2005> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/794329374#Agent/addison_wesley> ; # Addison-Wesley
    schema:url <http://proquest.safaribooksonline.com/0321262506> ;
    schema:url <http://proquest.tech.safaribooksonline.de/0321262506> ;
    schema:workExample <http://worldcat.org/isbn/9780321262509> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/316288906> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/794329374#Agent/addison_wesley> # Addison-Wesley
    a bgn:Agent ;
    schema:name "Addison-Wesley" ;
    .

<http://experiment.worldcat.org/entity/work/data/794329374#CreativeWork/microsoft_excel_computer_file> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/794329374#CreativeWork/microsoft_visual_basic_for_applications> # Microsoft Visual Basic for applications.
    a schema:CreativeWork ;
    schema:name "Microsoft Visual Basic for applications." ;
    .

<http://experiment.worldcat.org/entity/work/data/794329374#Person/green_john> # John Green
    a schema:Person ;
    schema:familyName "Green" ;
    schema:givenName "John" ;
    schema:name "John Green" ;
    .

<http://experiment.worldcat.org/entity/work/data/794329374#Place/upper_saddle_river_nj> # Upper Saddle River, NJ
    a schema:Place ;
    schema:name "Upper Saddle River, NJ" ;
    .

<http://id.worldcat.org/fast/1366659> # Microsoft Excel (Computer file)
    a schema:CreativeWork ;
    schema:name "Microsoft Excel (Computer file)" ;
    .

<http://id.worldcat.org/fast/1382545> # Microsoft Visual Basic for applications.
    a schema:CreativeWork ;
    schema:name "Microsoft Visual Basic for applications." ;
    .

<http://viaf.org/viaf/31509948> # Rob Bovey
    a schema:Person ;
    schema:familyName "Bovey" ;
    schema:givenName "Rob" ;
    schema:name "Rob Bovey" ;
    .

<http://viaf.org/viaf/68283039> # Stephen Bullen
    a schema:Person ;
    schema:familyName "Bullen" ;
    schema:givenName "Stephen" ;
    schema:name "Stephen Bullen" ;
    .

<http://worldcat.org/entity/work/data/794329374#CreativeWork/>
    a schema:CreativeWork ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/316288906> ; # Professional Excel development the definitive guide to developing applications using Microsoft Excel and VBA
    .

<http://worldcat.org/isbn/9780321262509>
    a schema:ProductModel ;
    schema:isbn "0321262506" ;
    schema:isbn "9780321262509" ;
    .

<http://www.worldcat.org/title/-/oclc/316288906>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/316288906> ; # Professional Excel development the definitive guide to developing applications using Microsoft Excel and VBA
    schema:dateModified "2017-11-08" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.