Hi,
I have a workbook with 1 data sheet from which a number of pivot tables are running. I use a button to initiate the RefreshAll command (in VBA) and the populate a label on the Menu sheet with the current date & time to indicate last update that took place. I also want to display the data source filename the user selected to do the refresh with. How do I extract that filename after the refresh was done in order to populate with the date & timestamp using VBA code?

I'm using Excel 2010.