HiTechCoach | Access Tutirials, TIPs, Examples
You are here:
Access VBA Office Automation
Access VBA Office Automation
Using Office Automation to have Access work with Excel, Word and other Office Applicaions.
Import Data from Microsoft Excel
Maybe you have noticed that Excel spreadsheets do not always import data very nicely into Access. Sure, Access can import data from various sources with just a few clicks, but Excel files seem to give the most grief. Out of necessity, I created a code module that employs automation to loop through rows of an Excel spreadsheet and systematically add data to an Access table, cell by cell. While this is not exactly a "cut and paste" solution for your data import, it does provide a nice starting point.
Export Data To Excel
... we look at how to get your data OUT of Access and back into Excel. While this may be as simple as right-clicking the table or query and choosing Export from the menu, it may also be complicated considerably by the need for custom formatting or the use of specific data templates. In the following article, we will demonstrate how to transfer your data into a prepared template using Excel Automation.
Set Word Document Properties Programmatically
by Ken Getz on MSDN
How to use automation to run Word mail merge from Access
This article shows you how to use Visual Basic for Applications to run a Microsoft Word mail merge in Microsoft Access.
How to Use Automation to Add a Task or a Reminder to Microsoft Outlook
This article shows you how to use Automation to add a task or a reminder to Microsoft Outlook.
How to send the current record to Word with automation
This article shows you how to merge the current record in a Microsoft Access object into a Microsoft Word document, to print it, and then to close Microsoft Word.
Fill in Word Forms Using Information Stored in Access
Although Access reports are flexible and relatively easy to create, they're not always suitable for every task. For example, your company may internally use manual forms that can easily be filled with data from an existing Access database. Your natural reaction is probably to create an Access report that replicates the hardcopy form, but a number of hurdles may prevent you from doing so. For instance, suppose that many other people have a continued need to fill the forms in manually. A consistent appearance between forms filled in manually and electronically is probably a requirement, so you could be looking at a lot of work to make the distinction between your Access report and the original form unnoticeable. In addition, the design of the forms is likely beyond your control?often maintained by someone using Word. Any time a form is modified, even cosmetically, you need to make changes to your Access objects. Fortunately, if the original forms are stored in Word, you can take advantage of the design work that's already been done. In this article, we'll look at how to populate Word documents with data from Access.
How to automate Outlook by using Visual Basic
This article demonstrates how to programmatically control Microsoft Outlook using Automation from Visual Basic. The example demonstrates creating contacts, creating appointments, and sending messages by using Microsoft Outlook's object-model.
Using Automation to Send a Microsoft Outlook Message
This article shows you how to use Automation to create and send a Microsoft Outlook message in Microsoft Access.
ACC2000: How to Build a Visual Basic Module to Print a Report in Landscape Mode on Legal-Size Paper
Office Template Store
What happens to those free Windows 10 upgrades after July 29, 2016?
Preview a Report and move to last page
Deploying Application (Front End) Updates
Microsoft Most Valued Professional MVP - Access Expert
Trust Center in Access 2007, 2010, 2013, and 2016
Why are there not many articles or examples for Access 2007, 2010, and 2013?
Splitting your Access database into application and data
What is the Access Runtime Version?