I have a workbook that I want a user to be able to easily change the source of the external data. the data is a table that was saved as an excel file. the external file will be saved each week as week 1, week 2, etc. I want the user to be able to run a macro that will prompt them which week they want to use as the external data and then have the macro change the source so the workbook will import the correct file.. thanks