using excel to automate word document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am interested in finding the most efficient way to automate a document. my
document is actually a model or format document. the dynamic language in the
document is either text or numbers (math cacluations).

i want to use something a bit more powerful than search and replace for the
text changes. i realize bookmarks and field codes are options. here are my
questions. which are easier to use and where should they be kept. Inside
the document (i.e. input pages at front of document) or external (another
word document or another office progam (such as access).

second, for the numerical replacements, in the past, I have calculated these
in excel, then had manually enterered them into an access database, whereby
they were "merged" into my source document. the problem here is I was
retyping much of the workbook or spreadsheet data more than once. I have
pretty much decided to group calculations in my document and just paste
special or paste special link from my workbooks into the document.

in summary, i am changing a lot of similar text fields and a lot of similar
number fields in my document and i just want to type the change in one place.
i would like to graduate from search and replace, so should i consider
bookmarks or field codes in a merge document?

thanks for your input.
 
keats said:
i am interested in finding the most efficient way to automate a
document. my document is actually a model or format document. the
dynamic language in the document is either text or numbers (math
cacluations).
Click to expand...
....

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.
 
i want to use something a bit more powerful
than search and replace for the text changes.
i realize bookmarks and field codes are options.
here are my questions. which are easier to use
and where should they be kept. Inside the
document (i.e. input pages at front of docu-
ment) or external (another word document
or another office progam (such as access).
Click to expand...

You can use the same VBA programming language in MS Word, MS Excel, and MS
Access, but the object models of each of these are quite different. That's
not surprising because you would expect to deal with different objects in a
word processor, a spreadsheet, and a database.

If it is convenient to calculate in Excel the values you want in the
document, and you do not need to save them in searchable database format, it
will likely be a shallower learning curve if you obtain a good book or two
on VBA programming for Word or Excel and do the work there.

If you do need to retain the calculated values to be able to regenerate the
same document, and you do not have legal requirements to save the document
itself, then Access would be a good "storehouse".

Larry Linson
Microsoft Access MVP
 
Back
Top