Get pivot table connection name by formula or udf

[alsacdb]

Is there a way to use a formula or UDF to return the name of a pivot table connection? The connection is to a locally saved *.csv file. I want it because I want to capture the date that makes up part of the file name. The connection changes weekly as the file is updated to capture new data. The filename changes as a date stamp is part of the name. The files are saved in a directory of folders by date so linking to name would not work since all files are in different folders. I am running 365 apps for enterprise in a windows 10 environment. Any help greatly appreciated. Here is one of the file names for reference: IMCNA_SWSNonInvoiced_20220314_125740 only the last part of the file name ever changes.