Home
Microsoft Office
Access
Access Tutorials
Access Downloads
Access FAQs
Access Links
Outlook
Outlook Blog
Outlook Links
Windows
Windows Blog
Windows Links
Site Index
Directory
Downloads
Links
Store
Access Tutorials, TIPs, Examples
Access Links
You are here:
Home
Microsoft Office
Access
Access Links
Access VBA Office Automation
Access Links
Access VBA Office Automation
Using Office Automation to have Access work with Excel, Word and other Office Applicaions.
Unpublished
Filter Field
Display #
5
10
15
20
25
30
50
100
All
Hits: 3089
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.
Hits: 3458
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.
Hits: 1773
Set Word Document Properties Programmatically
by Ken Getz on MSDN
Hits: 2597
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.
Hits: 1757
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.
Hits: 2803
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.
Hits: 3223
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.
Hits: 2114
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.
Hits: 1899
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.
Latest News
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