Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automation with MS Word (AXP / WORD XP)

    Can anyone shed some light on the process of using VBA code to automate exporting of data to a Word template? I would like to design a Word template that I can then open on demand and import Access data to it. I have discovered that the reporting tools in Access are limited and won't let you export things like logos. So I am thinking that the use of Word will allow more flexibility in this area.

    Thanks,
    Mark Santos

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation with MS Word (AXP / WORD XP)

    Mark,

    Have a look at the two articles I wrote at http://www.databaseadvisors.com/news...s/news0207.htm

    They talk about starting with documents and not templates, but it should be a good starting point.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation with MS Word (AXP / WORD XP)

    Thanks Bryan,
    I'll check it out. I need to use a template because this form will have formatting that needs to be fixed. I guess you could do that with a regular document though.

    Thanks,
    Mark

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation with MS Word (AXP / WORD XP)

    A template is probably the best choice.

    I wrote the article with the K.I.S.S. (Keep It Simple Stupid) method in mind, that's why I went with a document.

    But like I said, switching it to create a new doc based on a template should be fairly easy and straight forward.

    If not, ask.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automation with MS Word (AXP / WORD XP)

    Thanks! I checked out those documents you wrote. I believe it will suit my needs.

    Thanks,
    Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •