Open a file in a folder

[LonghronJ]

I know the exact path of a folder in the network by concatenating a couple of fields. Can someone write me the VBA to open the first file it finds in that folder? I say the first file, I presume there might be more than one file, but typically, in any given folder, there's only one file in each folder. I didn't know if it matters.

[pbaldy]

This returns the first file found in a folder:

strFileName = Dir("\\ServerName\FolderName\")

[LonghronJ]

Perfect. Thanks, pbaldy.

[pbaldy]

Happy to help!