How to run batch query in excel and get result into worksheet?
<p>At the moment I'm using batch file which contains this query:</p>

<pre><code>dir "\\directory\folder\example" &gt; file.xls /b /o
</code></pre>

<p>Once I execute it I receive .xls file which is used as data source in workbook.</p>

<p>Is it possible to run such a query once I open workbook and get data into specified worksheet?</p>