Excel 2002 VBA Programmer's reference

Stephen Bullen

,

Rob Bovey

,

John Green

,

Robert Rosenberg

Note moyenne 
Stephen Bullen et Rob Bovey - Excel 2002 VBA Programmer's reference.
VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do... Lire la suite
44,00 € Neuf
Actuellement indisponible

Résumé

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment. Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support.
Based on the successful content and format of Excel 200 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community. The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the feature available to Excel VBA programmers, with real-world examples answering frequently asked questions.
The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models. This book is not only caters for the beginners and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.

Sommaire

  • INTRODUCTION TO EXCEL
  • PRIMER IN EXCEL VBA
  • THE APPLICATION OBJECT
  • WORKBOOKS AND WORKSHEETS
  • USING RANGES
  • USING NAMES
  • PIVOTTABLES
  • FILTERED LISTS
  • GENERATING CHARTS
  • EVENT PROCEDURES
  • ADDING CONTROLS
  • OFFICE FILES AND FOLDERS
  • USERFORMS
  • COMMAND BARS
  • CLASS MODULES
  • ADDINS
  • AUTOMATION ADDINS AND COM ADDINS
  • SMARTTAGS
  • INTERACTING WITH OTHER OFFICE APPLICATIONS
  • DATA ACCESS WITH ADO
  • EXCEL AND THE INTERNET
  • INTERNATIONAL ISSUES
  • PROGRAMMING THE VBE
  • PROGRAMMING WITH THE WINDOWS API

Caractéristiques

  • Date de parution
    13/11/2001
  • Editeur
  • Collection
  • ISBN
    1-86100-570-9
  • EAN
    9781861005700
  • Présentation
    Broché
  • Nb. de pages
    993 pages
  • Poids
    1.7 Kg
  • Dimensions
    18,4 cm × 23,2 cm × 5,4 cm

Avis libraires et clients

Avis audio

Écoutez ce qu'en disent nos libraires !

Derniers produits consultés