I want a better solution

I wrote this football pool program which autoemails everyone in the pool sheets for them to put their picks on. They then email it back (saving the file as unique name so the program can automatically pick it up). The problem is:
a) The person in charge of the pool has to take each email (from 30 ppl) and store the attached sheet in a special location.
b) People keep changing the file name, which means that the main program, when compiling the picks into a master document, "doesnt find it".

I thought about adding an 'email back' button on each personal picks sheet, but then they have to toy with enabling macros and setting security levels (which i dont want to do for them)

Any thoughts for a better solution? Thanks!

I've done something similar.

For a) I automated Outlook from Excel, saving the email attachments to a folder, see http://www.*****-clicks.com/Excel.htm
The answer to b) is not to rely on each sheet having an exact name. I used FileSystemObject To process all Excel files in a folder, see code snippet:
(Set a reference to Microsoft Scripting Runtime to use FSO)

Please Login or Register  to view this content.