#1
|
|||
|
|||
PowerQuery to get Folder File Contents listing
Hello,
I've been reviewing files of hard copies in order to purge old reports for which we have a PDF version on our shared drive. Because they're in separate rooms, I was trying to find a workaround so I wouldn't have to lug a file drawer of papers to my desk and back. I found the option of using PowerQuery in Excel (we have 365) to list all the files in a folder. Since I know the start and end of the drawer, I used a temp folder to house only those digital files, and ran the query. It works pretty well for my purposes; I just have to whittle it down by filtering to the .pdf file types and then try to pick out the full reports. The columns it gives me by default are Content, Name, Extension, Date Accessed, Date Modified, Date Created, Attributes, and Folder Path. Is there a way to get it to add File Size? That's not essential to what I'm doing but it would be very helpful. Thanks, Ann |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 365 delete reminder you can’t make change to contents of this-read only folder | zillah | Outlook | 0 | 01-04-2021 01:54 PM |
Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option | Ismailc@parmalat.co.za | Excel | 0 | 09-16-2018 06:39 AM |
How capture a folder's file names to a file? | BobKnepper | Word | 2 | 05-22-2016 07:30 AM |
printing contents of folder | urkson | Office | 2 | 02-17-2012 07:45 PM |
Unsaved file contents retrieval | Muthukrishnan V | Word | 1 | 09-17-2011 10:29 AM |