Excel 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander - Collection Programmer to Programmer

1144 pages, parution le 20/04/2007

Ajouter à une liste

Indisponible

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.

L'auteur - John Green

John Green is founder of Execuplan Consulting, a specialist in Excel and Access business application development. The authors have each held Microsoft's coveted Excel MVP status for eight consecutive years, and are coauthors of Excel 2000/Excel 2002 VBA Programmer's Reference (Wrox Press).

Autres livres de John Green

Flocons d'amour - tie-in

Let it snow - le roman flocons d'amour à l'origine du film netflix

Flocons d'amour

Nos étoiles contraires

Découvrir tous les livres de John Green

L'auteur - Stephen Bullen

Stephen Bullen is founder of Office Automation Ltd., a specialist in Excel, Access and Visual Basic development that serves many of the world's largest businesses.

L'auteur - Rob Bovey

Rob Bovey is president of Application Professionals, a software developer specializing in Microsoft Office, Visual Basic, and SQL Server applications. He has developed several add-ins shipped by Microsoft with Excel.

L'auteur - Michael Alexander

Michael Alexander est développeur d'applications pour Microsoft. Il dispense également des conseils sur Excel et Access sur son site Web, www.datapigtechnologies.com.

Autres livres de Michael Alexander

Programmation VBA pour Excel 2019 pour les nuls

Découvrir tous les livres de Michael Alexander

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.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Collection	Programmer to Programmer
Parution	20/04/2007
Nb. de pages	1144
Format	18,5 x 23,5
Couverture	Broché
Poids	1468g
Intérieur	Noir et Blanc
EAN13	9780470046432
ISBN13	978-0-470-04643-2