Open PDF file knowing it's directory and only part of the unique file name.

[Travisty123]

Hi folks,

I'm looking for assistance with Excel. Looking for a method that will open PDF file knowing it's directory and only part of the unique file name. I'm hoping there's some sort of wildcard reference that can assist in doing what I need.

The data for the file name will be located in cell D4 and the data will contain "Q184645"

Located in the directory "C:\TESTQUOTES" is the file with the full name "Q184645_07_09_15_23-100622709.pdf"

[zbor]

If there is only one file with such name or you want to open first that match criteria then this can be simplified.

If there is multiple option use this:

In D1 enter folder where you save pdf's
Then click List files button to show all files using this name.
Then simply click on one you want to open.

[Travisty123]

There's an ever growing list of files, the only constant is that each file starts with Q and usually has 6 digits following (the rest of the data appears to be a time and date stamp for when the file was generated).

In theory there should be only one file with such a name (though there is the possibility that two people may add the same Q###### with a slightly different time and date stamp). I haven't actually thought about that possibility, but assuming it does happen, is it possible to load the newest file (meaning its the most recently updated)?

[zbor]

If you enter just Q in D4 then all files with Q will be opened (try).

[zbor]

This will sort them by last edited:

Please Login or Register  to view this content.