Access Links

Access Links

Access VBA Office Automation

Using Office Automation to have Access work with Excel, Word and other Office Applicaions.
  • Hits: 3259
    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: 3588
    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: 1920
    Set Word Document Properties Programmatically
    by Ken Getz on MSDN
  • Hits: 2758
    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: 1896
    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: 2942
    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: 3334
    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: 2237
    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: 2032
    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