title: VBA Excel prompt user to select a file in a default folder
body: <p>I would like to prompt user to open an Excel file in a default folder. I don't know how to open a default folder.                                         </p>
  
  <pre><code>Sub Program1()
      DefaultFolder = "C:\user\dump"
      FName = Application.GetOpenFilename
      If FName &lt;&gt; False Then
          Set WorkB2 = Workbooks.Open(FName)
          ' some codes here
      End If
  End Sub                           
  </code></pre>