Hi,
Excel 2007 question...
I have an Excel file that has tabs with csv files that can be refreshed. Users can choose to refresh the csv files and they can select from a list of csv's in a pre-populated library.
Once the user selects a csv I want to display the name of the csv that has been selected (so that the user is clear on the version of data they are looking at)
In short, is there a macro or formula that identifies the name of the csv that is currently selected in the external data connections?
-Kirk Souza
Excel 2007 question...
I have an Excel file that has tabs with csv files that can be refreshed. Users can choose to refresh the csv files and they can select from a list of csv's in a pre-populated library.
Once the user selects a csv I want to display the name of the csv that has been selected (so that the user is clear on the version of data they are looking at)
In short, is there a macro or formula that identifies the name of the csv that is currently selected in the external data connections?
-Kirk Souza
