Pivot - display source data filename after refresh
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1