Re: how do I link data from Word to excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi, Dan. A couple of questions:
-- I assume this is a matter of the Word document being an "individual"
work***, while the Excel workbook is a "master" list? For example, the
Word doc would be a single sales order form, and the Excel file has info
from all your sales?
-- How is the Word doc set up for data entry? Is it a protected form? Do
you tab from one entry field to another? Is it a table you fill in
manually? Does it grab info from a database?
-- Are all these files on your computer, or do you have to go across a
network?

Depending on how much is in one Word doc and how many you do each day, I'm
thinking you'd be looking at a macro to either run at the Save or Close of
your doc to grab the info and write it into Excel, or to run at the end of
the day to process all your files at once. If this is in a company
environment, will your company IT protocols allow you to run macros? And if
a network is involved, can you run a macro across your network?

Ed

"Dan Jones" <Dan Jones@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4997C304-89D4-4F41-88AF-56D3794D23A7@xxxxxxxxxxxxxxxx
I have a very, very large work*** in Word 2000. I also have the same
***
in excel 2000.

How can I link the 2 so when I'm filling in info in word certain parts of
it
will appear on the spread***?




.

Quantcast