zoom

Excel 2007 VBA Programmer's Reference

  • Nombre de pages : 1144 pages   drapeau anglais
  • Date de parution : 20/04/2007

Résumé

  • Fully updated and expanded to cover Microsoft Office Excel 2007, this book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications.
  • Begins with an overview of VBA, the programming language for the Microsoft Office suite and many other applications, which allows users to do anything from automating Excel tasks to developing full applications with Excel as the development environment.
  • The book then expands to focus on major issues faced by advanced Excel users and developers, such as setting up applications and converting them to add-ins, packaging and distributing Excel applications, and advanced debugging and handling techniques.
  • Features a reference section downloadable from the Web for easy perusal.

Sommaire

  • Primer in Excel VBA.
  • The Application Object.
  • Workbooks and Worksheets.
  • Using Ranges.
  • Using Names.
  • Filtered Lists.
  • PivotTables.
  • Charts.
  • Event Procedures.
  • Adding Controls.
  • Text Files and File Dialog.
  • Working with XML and the Open XML File Formats.
  • UserForms.
  • RibbonX.
  • Command Bars.
  • Class Modules.
  • Add-ins.
  • Automation Add-ins and COM Add-ins.
  • Interacting with Other Office Applications.
  • Data Access with ADO.
  • Managing External Data.
  • The Trust Center and Document Security.
  • Browsing OLAP Data Sources with Excel.
  • Excel and the Internet.
  • International Issues.
  • Programming the VBE.
  • Programming with the Windows API.

Caractéristiques

  • Parution : 20/04/2007
  • Edition : 1ère édition
  •  
  • Nb de pages : 1144 pages
  • Format : 18,5 x 23,5
  • Couverture : Broché
  • Poids : 1468 g
  • Intérieur : Noir et Blanc
  •  

mentions légales | conditions générales de vente | copyright © 2012
(1) livraison gratuite à partir de 49 € en France métropolitaine