Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET

av Rob Bovey, Dennis Wallentin, Stephen Bullen, John Green  (mixed media product, 2009)

Pris:  337:-
Skickas inom 5-8 vardagar.
Fri frakt vid beställning på minst 99 kr för privatpersoner i Sverige - Läs mer
Den här varan kan inte längre levereras innan jul.

Kundrecensioner

Bli först att betygsätta och recensera boken Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET.

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET

Fler böcker inom

  • Mixed media product
  • Språk: Engelska
  • Antal sidor: 1176
  • Utg.datum: 2009-05-01
  • Upplaga: 2
  • Förlag: ADDISON-WESLEY
  • Medarbetare: Wallentin, Dennis / Bullen, Stephen / Green, John
  • Illustratör/Fotograf: Illustrations
  • Illustrationer: Illustrations
  • Dimensioner: 230 x 175 x 55 mm
  • Vikt: 1840 g
  • Antal komponenter: 2
  • Komponenter: Paperback (1), CD-ROM (1)
  • ISBN: 9780321508799

Fler böcker av författarna

An Abundance of Katherines
John Green - The Collection
Looking for Alaska
Pappersstäder

An Abundance of Katherines

John Green
Häftad
87:-

John Green - The Collection

John Green
Häftad
305:-

Looking for Alaska

John Green
Häftad
87:-

Pappersstäder

John Green
Pocket
47:-

Bloggat om Professional Excel Development: The Definitive Guide...

Övrig information

Rob Bovey, president of Application Professionals, specializes in MS Office, VB, and SQL Server application development. He developed several Excel add-ins shipped by Microsoft, and co-authored the Microsoft Excel 97 Developers Kit and Excel 2007 VBA Programmer's Reference. Stephen Bullen, co-author of The Excel 2007 VBA Programmer's Reference, owns Office Automation, Ltd. Dennis Wallentin, has developed Excel solutions since the 1980s through his firm, XL-Dennis. John Green (Sydney, Australia) owns Execuplan Consulting, which specializing in Excel and Access development. All four are Microsoft MVPs.

Innehållsförteckning

Acknowledgments . . . xiv

About the Authors . . . xv

Chapter 1 Introduction

About This Book . . . 1

Who Should Read This Book . . . 2

Excel Developer Categories . . . 2

Excel as an Application Development Platform . . . 4

Structure . . . 7

Examples . . . 8

Supported Versions of Excel . . . 9

Typefaces . . . 10

On the CD . . . 10

Help and Support . . . 11

The Professional Excel Development Web Site . . . 12

Feedback . . . 12

Chapter 2 Application Architectures

Concepts . . . 13

Chapter 3 Excel and VBA Development Best Practices

Naming Conventions . . . 27

Best Practices for Application Structure and Organization . . . 40

General Application Development Best Practices . . . 45

Chapter 4 Worksheet Design

Principles of Good Worksheet UI Design . . . 69

Program Rows and Columns: The Fundamental UI Design Technique . . . 70

Defined Names . . . 71

Styles . . . 78

User Interface Drawing Techniques . . . 83

Data Validation . . . 88

Conditional Formatting . . . 92

Using Controls on Worksheets . . . 98

Practical Example . . . 100

Chapter 5 Function, General, and Application-Specific Add-ins

The Four Stages of an Application . . . 107

Function Library Add-ins . . . 110

General Add-ins . . . 117

Application-Specific Add-ins . . . 118

Practical Example . . . 125

Chapter 6 Dictator Applications

Structure of a Dictator Application . . . 141

Practical Example . . . 157

Chapter 7 Using Class Modules to Create Objects

Creating Objects . . . 166

Creating a Collection . . . 170

Trapping Events . . . 177

Raising Events . . . 180

Practical Example . . . 188

Chapter 8 Advanced Command Bar Handling

Command Bar Design . . . 198

Table-Driven Command Bars . . . 199

Putting It All Together . . . 219

Loading Custom Icons from Files . . . 228

Hooking Command Bar Control Events . . . 232

Practical Example . . . 241

Chapter 9 Introduction to XML

XML . . . 249

Chapter 10 The Office 2007 Ribbon User Interface

The RibbonX Paradigm . . . 273

An Introduction to the Office 2007 Open XML File Format . . . 274

Ribbon Design and Coding Best Practices . . . 278

Table-Driven Ribbon UI Customization . . . 289

Advanced Problem Solving . . . 291

Further Reading . . . 300

Related Portals . . . 300

Chapter 11 Creating Cross-Version Applications

Command Bar and Ribbon User Interfaces in a Single Application . . . 304

Other Excel 2007 Development Issues . . . 319

Windows Vista Security and Folder Structure . . . 326

Chapter 12 Understanding and Using Windows API Calls Overview . . . 331

Working with the Screen ...

Du kanske gillar...

The Second Machine Age

The Second Machine Age

Erik Brynjolfsson, Andrew Mcafee
Inbunden
216:-
The Legend of Zelda: Hyrule Historia

The Legend of Zelda: Hyrule Historia

S Miyamoto, E Aonuma
Inbunden
239:-
Minecraft : block, pixlar och att göra sig en hacka : historien om Markus "Notch" Persson och spelet som vände allt upp och ned

Minecraft : block, pixlar och att göra sig en hacka ...

Daniel Goldberg, Linus Larsson
Pocket
48:-
Datorteknik 1A V2011 : Lärobok

Datorteknik 1A V2011 : Lärobok

Jan-Eric Thelin
323:-