Problem extracting data from word form

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I am very new to word forms and most aspects of VBA. I was asked to create a
form for people to send in information, the form became pretty large over
time (as they do) and my initial method for capturing the data is looking
messy to say the least.

By continually being asked to add sections to the form the number of fields
has grown to 279 with 49 of the fields being required for the first stage.

In the beginning I used macros and simple vba to go through a directory and
extract the data into csv files and then import the data into excel. Now the
forms appear to be too large with data spanning more than two rows. Some of
the data is coming back with inverted commas thus confusing the import.

Can someone please point me in the right direction as to what I should use
(please be easy with the smart replies) and possible some tips on using the
..Result property

Thanks in advance

Phil
 
Hi Phil,

I wrote an article on this topic a couple of years ago for the now defunct MOD
(Microsoft Office Developer) magazine. Since then the archive has also been
pulled from the Internet, but is available with lots of other informative
articles on a CD: https://www.mssmartsolutions.com/Orders/cdorders.asp

You might want to check out the word.mvps.org website, as a lot of the basics
should be available there. And then direct any follow-up questions to the
word.vba.beginners newsgroup.
I am very new to word forms and most aspects of VBA. I was asked to create a
form for people to send in information, the form became pretty large over
time (as they do) and my initial method for capturing the data is looking
messy to say the least.

By continually being asked to add sections to the form the number of fields
has grown to 279 with 49 of the fields being required for the first stage.

In the beginning I used macros and simple vba to go through a directory and
extract the data into csv files and then import the data into excel. Now the
forms appear to be too large with data spanning more than two rows. Some of
the data is coming back with inverted commas thus confusing the import.

Can someone please point me in the right direction as to what I should use
(please be easy with the smart replies) and possible some tips on using the
..Result property
Click to expand...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :-)
 
Back
Top