Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Word data to a Excel spreadsheet
New Word user here. Question: Is it possible to link data that is entered
into a "fillable form" field, so that the identical data is ALSO entered simultaneously into a specified Excel cell? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Word data to a Excel spreadsheet
Hi MBR,
Yes, via vba (The macro language Word & Excel use). However, it's not something a new user is likely to find easy to set up, unless already fairly well experienced with vba. -- Cheers macropod [Microsoft MVP - Word] "MBR" wrote in message ... New Word user here. Question: Is it possible to link data that is entered into a "fillable form" field, so that the identical data is ALSO entered simultaneously into a specified Excel cell? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Word data to a Excel spreadsheet
Hi MBR,
Yes, via vba (The macro language Word & Excel use). However, it's not something a new user is likely to find easy to set up, unless already fairly well experienced with vba. -- Cheers macropod [Microsoft MVP - Word] "MBR" wrote in message ... New Word user here. Question: Is it possible to link data that is entered into a "fillable form" field, so that the identical data is ALSO entered simultaneously into a specified Excel cell? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Word data to a Excel spreadsheet
A "natural" way to do this in Office might be as follows:
a. type some text in Word and bookmark it, say using the name "mybm" b. select it, then in Excel, use Paste Special to insert it as text. You should see a formula in Excel along the lines of =Word.Document.12|'path\document.doc'!'!mybm' perhaps with {} around it c. type some characters in the middle of the text and verify that the change appears in Excel d. now create a form field (I'm assuming a traditional online form field, not an ActiveX control or a Word 2007 content control) e. in the field's properties, set the bookmark to mybm f. protect the form and type some data in, and see if the change is reflected in the Excel sheet. All that said, I have never used that technique "for real" and would not be surprised if it suffered from all kinds of difficulties. But if it does work, you can probably skip steps (a) to (d) and type the link code into Excel. Peter Jamieson http://tips.pjmsn.me.uk On 13/01/2010 23:51, MBR wrote: New Word user here. Question: Is it possible to link data that is entered into a "fillable form" field, so that the identical data is ALSO entered simultaneously into a specified Excel cell? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Linking Word data to a Excel spreadsheet
A "natural" way to do this in Office might be as follows:
a. type some text in Word and bookmark it, say using the name "mybm" b. select it, then in Excel, use Paste Special to insert it as text. You should see a formula in Excel along the lines of =Word.Document.12|'path\document.doc'!'!mybm' perhaps with {} around it c. type some characters in the middle of the text and verify that the change appears in Excel d. now create a form field (I'm assuming a traditional online form field, not an ActiveX control or a Word 2007 content control) e. in the field's properties, set the bookmark to mybm f. protect the form and type some data in, and see if the change is reflected in the Excel sheet. All that said, I have never used that technique "for real" and would not be surprised if it suffered from all kinds of difficulties. But if it does work, you can probably skip steps (a) to (d) and type the link code into Excel. Peter Jamieson http://tips.pjmsn.me.uk On 13/01/2010 23:51, MBR wrote: New Word user here. Question: Is it possible to link data that is entered into a "fillable form" field, so that the identical data is ALSO entered simultaneously into a specified Excel cell? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking word doc to excel spreadsheet | Microsoft Word Help | |||
Linking a graph from an excel spreadsheet to a Word Doc | Microsoft Word Help | |||
Linking an Excel Spreadsheet in Word | Microsoft Word Help | |||
Moving form data from Word to an Excel Spreadsheet? | Microsoft Word Help | |||
Merge data in Excel Spreadsheet into a word document | Mailmerge |