You really don't have to go into DAO with just Word and Excel. If you
were programming Word and Excel from outside the apps from VB or
Access, then that may be your answer. But if you are only using Word
and Excel, then the Visual Basic for Applications macro language
provided with these programs is powerful enough to do almost anything
you want.
For instance, I have an Excel spreadsheet "linked" to a Word report.
("Linked" is in quotes because it's not a link the way Microsoft uses
it; it's simply that these two go together.) At the moment, every
time I update this report, I need to update about 150 separate numbers
in various places in the document, plus pull in two whole-page tables
and import and embed five other Excel files. I click one button and
the process takes about 45 seconds (I have a slow computer!). It's
all done with macros - no ADO required.
The set-up was a bit tedious, but the time savings every two weeks
when I put out this report is well worth it!
Anyway, that's my experience.
Ed
On Mar 18, 11:02*am, binar wrote:
Thanks to all for posting. I have been researching this and something called
DAO seems to be the solution. The problem is that it seems to be very
complex. Does anyone understand DAO and how to use it with Word and Excel? I
found a link he
http://articles.techrepublic.com.com...3-1045296.html
Any additional info will be greatly appreciated.
"Suzanne S. Barnhill" wrote:
Can you embed the Excel worksheet in your doc?
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"binar" wrote in message
...
Fellow Forum Members,
I am using Word 2003 for a technical manual that has close to 300 pages of
tables containing parts data. *This parts data is changing all of the time
due to engineering making changes all of the time. Updating these 300
pages
of data is a major pain. *My thinking is I should manage all of this data
in
Excel and then perform a mail merge of some kind to update 300 pages
automatically. What is the best way to go about combining external data
into
Word? *I would like each cell in my Word table to match every cell in the
my
Excel file one for one. *What is the best function to use? *Is there an
automated way to setup the cells in my Word tables so that each cell
matches
a cell in my Excel table? *I would like to do this right, any help will be
greatly appreciated. Thanks.- Hide quoted text -
- Show quoted text -