I have a button on an Access 2013 form that will open a pdf file from a directory on a server using a wild card character in the file name as below. I want to search all subdirectories rather than just the "imaging" subdirectory. Is there a simple way to do this using wildcards in the path?
I have limited skills in VBA. Any help would be appreciated.
Private Sub Command0_Click()
Call Shell("c:\Program Files (x86)\Adobe\Acrobat 9.0\Acrobat\Acrobat.exe \\winr2\imaging\*16896.pdf").