Maybe this will help
http://www.rondebruin.nl/mail/folder2/saveatt.htm
Then use the add-in or code to merge
http://www.rondebruin.nl/merge.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"mttmwsn" wrote in message ...
I need to get excel spreadsheets from 30 people once a week.
Instead of having the spreadsheets e-mailed to me, I need to automate the
process. I thought about seting up an ftp site but we have the budget for a
better solution. MS SharePoint seems like overkill because it's not a
collaborative project. I just want to get their data and also possibly let
them correct their data if they make a mistake.