excel - vba: how do i open a file if i only know part of the file name? -

I need to open a file whose full filename I do not know.

I know the file name is something like this.

  file name * esy  

I definitely know that there is only one instance of this file in the given directory.

file name * esy is already a "shell ready" wildcard & Amp; If it is that in case you can easily; String file = Dir $ (SOME_PATH & amp; filename * esy) & amp;; as the file \

  const SOME_PATH string = "c: \ rootdir \" ... ". *") If (lane (file)> msbbx "got" & amp; file end if  

simply empty blank (or empty) file = Dir $ () to get the next match.