Linking word to excel

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

Guest

Hi, I have a document that the nurses at the hospital I work out fill out reguarly and we were working on a way to track and graph the results for future reference. One idea was that we try to link the word document so that when they filled in this form on their computers it could update an excel document that would be in a shared folder they could all have access to. Does this sound possible to anyone? Thank you.
 
Hi =?Utf-8?B?THVrZSBHYXJyZXR0?=,
I have a document that the nurses at the hospital I work out fill out reguarly and we
Click to expand...
were working on a way to track and graph the results for future reference. One idea was
that we try to link the word document so that when they filled in this form on their
computers it could update an excel document that would be in a shared folder they could
all have access to. Does this sound possible to anyone?I don't think this is going to work with simple links. Links are rather static things;
while you could link certain text to an Excel cell, it would always be to the same cell.
And I assume you'd want each new document to start in a new row?

Something like this is going to require VBA; probably to extract the information from the
document and transfer it to Excel or a database program. And exactly how code like that
would look will depend a lot on how this documents is set up. (Does it use form fields,
for instance?)

A different approach to consider would be to enter the information in a database, then
have that generate the report document.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)
 
Thank you for your reply. If it is possible, we will need new data to be entered on a new row. The document has several form fields that they can enter information to. Things like what shift they are and problems that occured and we were looking for a way to get all of that information to go together to the excel document so that we can see what happened and on what shift. Do you have any advice on what to do in VBA? Thank you very much.
 
Hi =?Utf-8?B?THVrZSBHYXJyZXR0?=,
If it is possible, we will need new data to be entered on a new row. The document has
Click to expand...
several form fields that they can enter information to. Things like what shift they are
and problems that occured and we were looking for a way to get all of that information to
go together to the excel document so that we can see what happened and on what shift. Do
you have any advice on what to do in VBA?You'll find articles on the word.mvps.org website that describe how to pass data from
Word to Excel using VBA. Look at those to understand this part.

to get the data from a form field into VBA, you'd use
ActiveDocuments.Formfield("Name").Result

Feel free to come back with specific questions, once you've got the background from the
articles, and tried things out :-) Note that the better place to ask, then, will be the
word.vba.beginners group :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail :-)
 
Back
Top