I have a workbook setup to query other excel files to populate a worksheet. I am wondering if there is a way to prompt for the filename to do the query? I have an automated report that runs every day with the date as part of the filename, so the previous days data does not get overwritten. I am wanting to be prompted for the filename on the database query when the workbook is opened and refreshes the data, that way I can look at a specific days data.
Thanks
