title: How can Excel VBA open file using default application
body: <p>I want an Excel spreadsheet that has a file path and name in column A.  When a macro is run, let's say the file specified in A1 should be opened on the user's machine.  The file could be .doc, .xls, .txt, etc....  rather than my vba needing to know the full path the to application, how could I have the vba tell the machine "please open this file and use your application associated with the extension" ?</p>
  
  <p>I have already found this to work with the full path:</p>
  
  <pre><code>dblShellReturned = Shell("C:\Windows\System32\notepad.exe myfile.txt, vbNormalFocus)
  </code></pre>
  
  <p>how could I get it to work with something like:</p>
  
  <pre><code>dblShellReturned = Shell("myfile.txt", vbNormalFocus) ' how do I get this to work
  </code></pre>
  
  <p>Thank you in advance!</p>