Can I Use Wild Cards?

'I have a scheduling worksheet with command buttons for opening PDF drawings stored in a shared drive folder. I will always know the first 11 characters of the file name, but not the length or value of the rest. Folks have started adding descriptive text to the end of their file names for easier reference.
Here is the code:

Please Login or Register  to view this content.

'ThisFile is the folder, ThatFile is the first 11 characters

'Any help would be appreciated and Thanks

So maybe:

Please Login or Register  to view this content.

That is the syntax I use for opening files with wildcards. The * covers any number of characters between the known string and the .pdf.

1) ThisFile needs to end in \
2) Let's pull the filename in from the Windows directory before we try to open it.

Please Login or Register  to view this content.

Thanks for the tip on the \

I could not get it to work, but came across another tip and adapted it to my needs. All is well. I do wish to be able to include something to look in Subfolders. The files could be in the main folder or a couple of subfolders. This code looks in a particular folder following the hyperlink. Thank you again for your assistance.

Please Login or Register  to view this content.