Link forms in word to cells in Excel

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

Guest

I have Microsoft Word and Excel 2000. What I want to do is link form fields from word into an excel spreadsheet. These form fields are already set up to total amounts, I just want them linked to excel so when each form field totals, a new excel cell pops up with that dollar amount in it. Is this just impossible to do? I can link the entire document to excel, but not a specific form field. Any advice would be greatly appreciated.
 
Hi =?Utf-8?B?QWRyaWVuZSBH?=,
I have Microsoft Word and Excel 2000. What I want to do is link
Click to expand...
form fields from word into an excel spreadsheet. These form fields
are already set up to total amounts, I just want them linked to excel
so when each form field totals, a new excel cell pops up with that
dollar amount in it. Is this just impossible to do? I can link the
entire document to excel, but not a specific form fieldWell, I don't think you can get Excel to "pop up a new cell", but you
should be able to link the information from a form field into a
specific cell.

First, select some text and insert a bookmark into a Word document.
Copy that, go into Excel, Edit/Paste Special. Choose "Text" as the
format and activate "Paste link". Now take a good look at what Excel
puts in the cell's formula; it should resemble this:

=Word.Document.8|'C:\Documents and Settings\xaz\My
Documents\TestRemovePersonalData.doc'!'!Test2'

Every formfield has a name; you can see it by double-clicking the
field to open the Options dialog box. This name is also a bookmark.

So, all you need to do is use the basic formula, like above, and put
in the correct file path and bookmark name (Test2, above).

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 so much for your help! It worked perfectally. Is there any way for me to run a macro or something of the sort that I would be able to run that entire process on the forms I need copied, instead of doing them individually? Also, is there a way that when I fill out one form, it copies into another one in the same document? Thank you so much again
~Adrienne~
 
Back
Top