title: Running Sub in Another Excel Workbook with Variable File Name
body: <p>I currently run a sub in another (open) workbook using this line:</p>
  <pre><code>Application.Run (&quot;'NDS Analytics.xlsm'!Process&quot;)
  </code></pre>
  <p>The names of the referenced workbooks are changing so I would like to change the reference so that instead of looking for file NDS Analytics.xlsm it looks for an open file that contains the words &quot;NDS Analytics&quot;.</p>
  <p>There will only ever be one file with this name open at a time and it could be called either NDS Analytics.xlsm, wNDS Analytics.xlsm or 40ghNDS Analytics.xlsm.</p>