Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to save form fields
Anyone know how to retrieve form fields from a word doc
that's been opened by visual basic? I want to grab them when the doc is closed (preferably), then write them to an Access database. |
#2
|
|||
|
|||
Hi Will,
Anyone know how to retrieve form fields from a word doc that's been opened by visual basic? I want to grab them when the doc is closed (preferably), then write them to an Access database. No way to extract form field information from a closed Word document; you'd have to open it. Or the user would have had to save the document as "data only". In the opened form document you extract the form field result: doc.FormFields(index).Result Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-) |
#3
|
|||
|
|||
Hi Cindy-
What I meant was how do I grab the field data UPON closure of the document - not when the doc is already closed. Also, how can I save the document as "data only"? -----Original Message----- Hi Will, Anyone know how to retrieve form fields from a word doc that's been opened by visual basic? I want to grab them when the doc is closed (preferably), then write them to an Access database. No way to extract form field information from a closed Word document; you'd have to open it. Or the user would have had to save the document as "data only". In the opened form document you extract the form field result: doc.FormFields(index).Result Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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- :-) . |
#4
|
|||
|
|||
"Save data only for forms" is a document option on the Save tab of Tools |
Options. Set this property on your forms template, and it will apply to all documents based on it. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Will Goldring" wrote in message ... Hi Cindy- What I meant was how do I grab the field data UPON closure of the document - not when the doc is already closed. Also, how can I save the document as "data only"? -----Original Message----- Hi Will, Anyone know how to retrieve form fields from a word doc that's been opened by visual basic? I want to grab them when the doc is closed (preferably), then write them to an Access database. No way to extract form field information from a closed Word document; you'd have to open it. Or the user would have had to save the document as "data only". In the opened form document you extract the form field result: doc.FormFields(index).Result Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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- :-) . |
#5
|
|||
|
|||
Hi Will,
What I meant was how do I grab the field data UPON closure of the document If you have the choice of using a macro saved in the document, or its template, then use a macro named FileClose (will fire when the document is closed). Otherwise, if you're automating this from outside of Word, you'd need to link up to the Document_Close event on the document object variable. For more help you should really be in one of the word.vba or possibly office.developer newsgroups. This is a group for end-user questions (as you'd have noticed if you'd read a few messages before posting). Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) 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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As...*.txt files | Microsoft Word Help | |||
spell check form fields | Microsoft Word Help | |||
Linking dropdown form fields | Microsoft Word Help | |||
Text boxes in protected Doc, form fields | Microsoft Word Help | |||
On a form in Word, the text in the fields comes out red, and a bo. | Microsoft Word Help |