I want to use the transferdata option in the macros to automate import of excell spreadsheets but i want it to prompt the user to enter the excel spreadsheet. Because it will be a different file and location each time. I did a search but didn't come up with anything i could use. Any suggestions?