Hmmmm... a second method (still doesn't overcome the file naming problem)
would be to put a macro into the questions.xls file that you could run when
it is returned to you that would dump the information into the answers.xls
file. Then as you had them returned, you could open the attachment, run that
macro and then just close the opened attachment without saving it. Not a
batch process, per se, but is feasible. Just be sure that the macro exits
gracefully if it cannot find the answers.xls file on a system - you may have
some curious questionnaire recipients out there that will give it a go just
to see what it will do.

The problem with this option is that you may also 'scare' some of the folks
who get the questionnaire if they get the big "This file contains Macros ...
Enable, Disable,??" warning. I'd look more seriously at something like my
earlier suggestion because of this.

"Beav" wrote:

Let's say I have a spreadsheet(questions.xls) that represents a
customer questionaire, formated in a fancy page layout. I will email
that questionaire to 1000 people. They will fill it out and email it
back to me.

I have this other spreadsheet(answers.xls) that is just a table of
data, representing the answers.

I want to just drag the many returned questions files and drop one or
more onto a batch file, or perhaps onto ahswers.xls itself, and have a
macro copy over the data to the answers table and then leave the
original in place.

Any ideas?

Thanks.