I have created a Form named abc.dot in Word. A respondent fills in the
form, and saves the file as abc-01.doc and sends it to me. And
likewise, from other respondents I get files named abc-02.doc,
abc-03.doc, etc.

All these files abc-01.doc, abc-02.doc, abc-03.doc, etc. have been
saved in one folder.

I would like to have an Excel file contain the responses given in each
of these files.

Can anyone please suggest a macro to do this?

Many thanks.


--
arunjoshi
------------------------------------------------------------------------
arunjoshi's Profile: http://www.excelforum.com/member.php...fo&userid=8846
View this thread: http://www.excelforum.com/showthread...hreadid=526715