title: Select File from folder
body: <p>Request to help me on below query.
  From a folder I want the file to be selected, I could retrieve the file name but could not select the file in folder, should just highlight the file. I am using the objFile.Name.Select but it is through exception as object required 424</p>
  
  <pre><code>Set objFSO = CreateObject("Scripting.FileSystemObject")
  Set objFolder = objFSO.GetFolder("C:\Users\Desktop\New folder")
  For Each objFile In objFolder.Files
      MsgBox objFile.Name
      objFile.Name.Select
     If InStr(objFile.Name, "Document Error") &gt; 0 Then
         Exit For
     End If
  Next objFile
  </code></pre>