Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Moving form data from Word to an Excel Spreadsheet?
After creating a form in word using various field types, need to know how to
gather that data automatically into an Excel spreadsheet? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Moving form data from Word to an Excel Spreadsheet?
Hi ?B?Si5Qb2xheWVz?=,
After creating a form in word using various field types, need to know how to gather that data automatically into an Excel spreadsheet? "field types" as in form fields from the Forms toolbar? Or something else? Version of Word? There is no functionality that will automatically transfer data in a Word document to Excel. A document with form fields can be set to save ONLY the data entered into the form fields (see Tools/Options/Save). This creates a comma-delimited text file, which can then be imported into an Excel spreadsheet (one-by-one). This is the only possibility that doesn't involve programming (macros). Getting into the realm of macro programming, you could have a macro in Excel that would import, say, all the csv files in a folder, so that you wouldn't have to do it one at a time. You could also have a macro in Word that would read the information directly from the form fields and write it to an Excel file. I think there are a couple of tutorials on automating Excel from Word (or Word from Excel) that might give you start on this at word.mvps.org. 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 :-) |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Moving form data from Word to an Excel Spreadsheet?
Hi ?B?Si5Qb2xheWVz?=,
Thank you, if you know of an easy way to move field data from word to excel w/orwo macros I would appreciate the heads up. I am trying to update and gather data supplied by teachers etc. in email responses. As I said, start with the tutorial at word.mvps.org... Then post again with specific questions where you get stuck. But it would be better to post in a word.vba newsgroup, rather than in this one (which is meant for end-user questions) 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 | |||
Copying Excel data into Word: setting the Tabs | Page Layout | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Create a form in excel and word that locks in the user's data so . | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout |