title: Use Excel to open a search window in Window Explorer
body: <p>I have seen some topics on the subject, but I haven't been able to find exactly what I need. And because I am not familiar with VBA I have not been able to tweak the code to get it to work.</p>
  <p><strong>Here's what I am looking to accomplish:</strong></p>
  <p>I would like to have a macro (or excel formula) that when I click on the hyperlink it will open a Windows File Explorer in search mode.</p>
  <p>In cell A1 is my path name (C:/users/images)</p>
  <p>In cell A2 is the file name (Butterfly)</p>
  <p>In cell A3 is the hyperlink that when I click on it it will open windows file explorer searching in the path C:/users/images for any files containing butterfly</p>
  <p><strong>Here is what I have found so far</strong></p>
  <pre><code>Sub SearchFolder()
  
  Call Shell(&quot;explorer.exe &quot; &amp; Chr(34) &amp; &quot;search-ms:query=butterfly&amp;crumb=location:C:\users\images&quot; &amp; Chr(34), vbNormalFocus)
  
  End Sub
  </code></pre>
  <p>This bit of code works, but it is hard coded. I need to made it dynamic so that the marco can pick up the the path and file name from the excel cells.</p>
  <p>Any help is great! And like I said I am not familiar with VBA (it took me 3 days to find that code) so if you can provide the code as will that would be great!</p>