Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word Forms
Hello All,
I have a quite a few different Word docs that have spaces for people to fill in sales figures. I would like the figures to be automatically transfered into an Excel spreadsheet which I then use to do calculations. I thought I could add form fields to the document and somehow get these into Excel. Can this be done, and if so any help would be greatly appreciated. Regards Julia |
#2
|
|||
|
|||
Hi Julia,
I have a quite a few different Word docs that have spaces for people to fill in sales figures. I would like the figures to be automatically transfered into an Excel spreadsheet which I then use to do calculations. I thought I could add form fields to the document and somehow get these into Excel. This can be done, but it requires VBA programming if you want it to happen automatically. There's also an option to "Save data only" for a form that creates a delimited text file containing only the form field information. This could be imported into Excel... 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 | |||
How can I divide a page into three sections? | Microsoft Word Help | |||
Is there a Fast Search in Word? | New Users | |||
Basic macros query - where are they assigned to? | New Users | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help |