export form info

[Guest]

I have a form that has a vendor name and then 1 to 5 entries. I would like
to export the information to a table or excel but I would like to send
several of theses filled out forms to the same list through out the week.
How do I do this? I want the vendor name listed with each entry. Does this
make any sense? Help! Here is an example of the list that would come from
only 2 forms, one for each vendor.

Vendor ABC $40.00 5252336 1/20/06
Vendor ABC $66.00 4458223 1/22/06
Vendor XYZ $52.55 1112522 1/25/06

Thanks!!!
Bethany

 

[Cindy M -WordMVP-]

Hi Bethany,

If you're talking about forms created with Word's form fields (Forms toolbar),
then you can set such a form to "Save data only" (Tools/Options/Save).

That gives you a delimited text content
VendorABC, 40.00, 5252336, 1/20/06
for each form, in a *.txt or *.csv file.

Excel can import this content with no problems (Data/Import). It should be
possible to create a fairly simply macro program that would import the content
of all files in a directory, if you like. You'd want to ask in an Excel group
about that.

It would also be possible to extract the data from Word and write it to Excel
or something else, but this macro would be a bit more complex. The basic
building blocks can be found on the word.mvps.org website (reading results from
form fields; writing data to Excel). If you want to pursue this, then you
should ask in a word.vba newsgroup, where macro programming is discussed.

I have a form that has a vendor name and then 1 to 5 entries. I would like
to export the information to a table or excel but I would like to send
several of theses filled out forms to the same list through out the week.
How do I do this? I want the vendor name listed with each entry. Does this
make any sense? Help! Here is an example of the list that would come from
only 2 forms, one for each vendor.

Vendor ABC $40.00 5252336 1/20/06
Vendor ABC $66.00 4458223 1/22/06
Vendor XYZ $52.55 1112522 1/25/06

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

 

[expert-services]

You can try our automation software, Automation Anywhere. You can get
more information and free trial download for Automation Anywhere from
http://www.tethyssolutions.com/automation-software.htm

It can import CSV files and used for many data transfer tasks. You can
see examples here
http://www.tethyssolutions.com/automation-samples.htm#data

Tethys Solutions, Expert Services Group
http://www.tethyssolutions.com/ask-the-expert.htm
SMART Macro & Automation Solutions