Using a template without destroying the template

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

About 2 months ago I started writing a database application in VBA and
Access. This was my first ever attempt at using Access and my first
ever attempt to program in VBA.

The Access app is coming along nicely, it does most of the basic data
input stuff. The next step is to get it to fulfill its true purpose,
passing data to Excel and Word (and from Excel to Word) in order to
create some fairly complex documents.

My first stumbling block is that while I've picked up a modest amount
of knowledge about Access development, and an even more modest amount
of knowledge about Word development, I still haven't figured out how to
do cross-application development.

I want to do a bunch of stuff in Access which saves some values to a
table, then click a button in my Access app which will take a copy of a
template Word document, which consists only of a bunch of bookmarks,
and copy sections from another Word document with a bunch of canned
text into the new document at the various bookmark places, then save
the new document as <client name> & <today's date>, then open the
document for editing by hand.

Can anyone give any pointers, or links, so I can manipulate Word
documents in this manner from within an Access app? (NB: I'm writing
for Office XP and Office 2003)

Thanks.

Travis

.

Relevant Pages

  • Re: quick question - yes or no?
    ... invested, say, three years in writing something, they might be left ... The big money goes to the ... interest in writing bunch of crap novels. ...
    (misc.writing)
  • Re: quick question - yes or no?
    ... invested, say, three years in writing something, they might be left ... The big money goes to the ... interest in writing bunch of crap novels. ...
    (misc.writing)
  • Re: quick question - yes or no?
    ... invested, say, three years in writing something, they might be left ... The big money goes to the ... interest in writing bunch of crap novels. ...
    (misc.writing)
  • Re: Official Status of SQLServer 2005 ADP
    ... As we started out looking at writing a replacement for the old Access app ... > It's fairly obvious that much of the new high-level developments in the ... > database domains will be done for the .NET Framework only; ...
    (microsoft.public.access.adp.sqlserver)
  • Re: quick question - yes or no?
    ... invested, say, three years in writing something, they might be left ... the idea of investing time and effort on something that may ... interest in writing bunch of crap novels. ...
    (misc.writing)