Excel 2007 VBA Programmer's Reference

Name: Excel 2007 VBA Programmer's Reference
Price: 6.75 USD
Availability: InStock
ISBN: 9780470046432

ISBN-10: 0470046430

ISBN-13: 9780470046432

Edition: 2007

Authors: John Green, Stephen Bullen, Rob Bovey, Michael Alexander

List price: $39.99

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $6.75

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Updated and expanded for the most up-to-date version of VBA, this volume covers the basics of using Excel and VBA. The authors explore a range of new topics related to using the software more effectively and solving the many issues faced by developers.

Book details

List price: $39.99
Copyright year: 2007
Publisher: John Wiley & Sons, Incorporated
Publication date: 3/26/2007
Binding: Paperback
Pages: 1176
Size: 7.25" wide x 9.25" long x 2.25" tall
Weight: 3.190
Language: English

MICHAEL ALEXANDER is the pseudonym of a nurse who has previously worked in the UK and New Zealand.



Acknowledgements


Introduction



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



Excel 2002 Object Model



VBE Object Model



Office 2007 Object Model


Index