Can wildcards work for opening files with a button using standard functions? I folders with files that change names a lot (filename currentDate.xlsx) and wanted a button that would open the one in the folder, since old ones are moved to a sub-folder.
I.E. open “filename *.xlsx”. Any way to do this with standard functions?
I was thinking of trying to maybe do this with a VBScript function using FSUtil.Wild, but it only returns true or false, and not the string it found? I don’t understand its usefulness if you can’t get the matched string.