Linking from Access to Word Template

  • Thread starter Thread starter Colleen
  • Start date Start date
C

Colleen

HI I need to create a link from Access to a Word Template
which has Visual Basic Code. However, when I create the
hyperlink in Access and point the address to the word
template, it opens the .dot file in Word. I need it to
open the template as a .doc file and to run the VB code in
the Word Template. I would really appreciate any help.
Thank you
 
Hi Colleen,

Yes, a hyperlink just opens the document it points to. You'll need to
use Automation to launch Word and create a document based on the
template. See e.g. http://www.mvps.org/access/modules/mdl0043.htm

See the following links for more about automation:

ACC: Sending the Current Record to Word 97 with Automation (Q131583)
http://support.microsoft.com/?id=131583

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235
 
Back
Top