Thank you very much for the help. This helps out a lot.

Is is possible to set the $File1 variable to be any excel file (*.xls)? The way I envision this script working is that it is set to run every 5 minutes or so. Someone will drop an Excel file in the folder with any filename and the script will pull it and process it. The filenames will vary from file to file. Is it possible to do this?

Thanks.