This book is a fairly comprehensive resource on writing VBA code to exchange data among the main Office applications (Access, Word, Excel, and Outlook), using Access as the central application for storing data, and using the other applications for producing attractively formatted documents of various types.
By the time you have completed the Access 2007 VBA Bible, you will be well-prepared to write VBA Automation code that uses your Access data to produce Word letters, mailing labels and other documents (without the overhead of mail merge), to create Excel worksheets and PivotCharts, and to create Outlook appointments, mail messages, contacts, and journal items, with or without attachments. Additionally, you will be able to synchronize contact data (both ways) between Access and Outlook.
The book is written for the Access/Office developer or power user who is familiar with working with Office applications (particularly Access) in the interface, and has at least a basic familiarity with writing VBA code, but needs more information on how to write Automation code to work with Word, Excel, and Outlook objects, so as to be able to use each Office application for creating the documents that are its specialty, while storing most of the data in Access databases.
To run the sample code in this book, you need a computer capable of running at least Windows XP, and of course you need Office 2007. Because Office 2007 runs fine on Windows XP, you don’t need Windows Vista, but Office 2007 works even better on Vista.
TABLE OF CONTENT:
Chapter 01 - Storing and Displaying Data in Access
Chapter 02 - Creating Word Documents from Access
Chapter 03 - Analyzing Data with Excel
Chapter 04 - Organizing and Communicating with Outlook
Chapter 05 - Working with Access Data
Chapter 06 - Working with Word Documents and Templates
Chapter 07 - Working with Excel Worksheets
Chapter 08 - Working with Outlook Items
Chapter 09 - Working with Files and Folders
Chapter 10 - Working with External Data
Chapter 11 - Synchronizing Access and Outlook Contacts
Chapter 12 - Going Beyond the Basics
Chapter 13 - Creating COM Add-ins with Visual Basic 6
Chapter 14 - Creating Access Add-ins
Chapter 15 - Customizing the Ribbon with XML in Access Databases and Add-ins
Chapter 16 - Customizing the Access Ribbon with a Visual Studio 2005 Shared Add-in
Chapter 17 - Creating Standalone Scripts with Windows Script Host
Chapter 18 - Working with SQL Server Data
:::Download Here:::
