I've got a VB Script that is used to convert Excel workbooks to PDF. The workbooks each have an external data range populated from a CSV file. The data range properties are set to refresh on file open. The script simply opens the workbook, does a RefreshAll to refresh the CSV data and then does a SaveAs PDF. Works fine.

What I want to do is put an indicator in the output that shows the date the data was refreshed (the date of the CSV file). My thought was to just put this into a cell above the data range. I can't figure out how to get the properties of the data range (specifically the CSV file name/path) from VB Script. Another possible solution would be to have a way for the external data range date/version to be populated in a cell on the refresh of the data range (if that is possible). I'm open to other suggestions on how to show the "version" of the external data as well. Any help appreciated.