We have a bunch of Excel documents which gets tossed around a lot. Every time somebody makes a copy of a file, in windows it gets generated as 'Copy of - <filename>.xlsm'
. We would like to extract the filename of each file it was assigned originally/first time i.e. get '<filename.txt>'
instead of 'Copy of - <filename>.xlsm'
.
I tried looking at the file properties such as Tag, but these fields have not been set for some of the files already distributed. Is it possible to extract the filename of a file that originally assigned? (using VBA or Powershell scripting)