Power Query to filter files on a network share

powerquerytofilterexcelfiles.png

<div>
Hi teylyn - brilliant tool, had not know that this existed but after downloading and using it seems like a useful utility. <br />
<br />
Hi Phillip - quick question on your word of caution and thanks for highlighting this. Do you know why they are not 100% reliable? I will be looking at date modified and date last accessed - can these report incorrectly?
</div>


Hi teylyn - brilliant tool, had not know that this existed but after downloading and using it seems like a useful utility.

Hi Phillip - quick question on your word of caution and thanks for highlighting this. Do you know why they are not 100% reliable? I will be looking at date modified and date last accessed - can these report incorrectly?

<div>
Thanks Phillip - sorry I had not realized this link was about the reliability of the dates! Thank you.
</div>


Thanks Phillip - sorry I had not realized this link was about the reliability of the dates! Thank you.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a network share full of Excel files. Is there an approach or way in which I can output into a file the Path/URL of the Excel file and the date on which it was last modified where the file type is excel and the word &quot;Workbook&quot; is in the title of the excel file?<br />
<br />
Thanks in advance<br />
<br />
GISVPN
</div>
</div>


Hello,

I have a network share full of Excel files. Is there an approach or way in which I can output into a file the Path/URL of the Excel file and the date on which it was last modified where the file type is excel and the word "Workbook" is in the title of the excel file?

Thanks in advance

GISVPN

Date Excel File Last Updated

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.