When creating a macro, you can access the standard Open dialog box so that a user can select a file to process. This tip explains how to do that and grab the selected file name from the dialog box. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) Read this ExcelTip: Getting a File Name Microsoft Excel Tips - Master Excel's Power!
