I have a need to export the contents of a Windows Folder Directory to an Excel Spreadsheet. This folder is not on my local drive, it is on a file server. I am using Excel 2010 and have the Power Query add-in which almost does exactly what I need with the exception of bringing in the meta data...