Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 02-23-2023, 06:32 AM
kilroyscarnival kilroyscarnival is offline Power Query to get a list of folders (not files) in a location? Windows 10 Power Query to get a list of folders (not files) in a location? Office 2021
Expert
Power Query to get a list of folders (not files) in a location?
 
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by p45cal View Post
How extensive are the folders below FPath?
Are we talking urls, sharepoint, or just the local hard drive?
It's a rather large shared drive (1.99 TB) with lots of sub-folders and sub-sub folders. The funny thing is that the regular Power Query search from which I filtered for the folder paths that have *Invoices\ in them doesn't take nearly that long, so I guess your method is more complex. Appreciated, but I think it's just not going to be practical. I don't think it's a credentials issue, though.

Quote:
Originally Posted by p45cal View Post
The path in the named range FPath is used as a top, starting folder, but it doesn't have to be; the query could use it differently, but I don't think it would necessarily speed things up. The query I showed doesn't try to process further the results - I wpould expect the query to be added to for that. It was only meant as a starting point.
Yup, last night I pulled it back up before I left and I attempted to add a filter to the results. It had all night to run, but I must have done something wrong as it came up empty. I'm tending to think I'll go with what I have, and if I need to look up a few file paths manually that were empty folders, I'll just keep those results in a file so I won't need to do too much in any month.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel power query help ganesang Excel Programming 0 09-20-2021 01:50 AM
Browse, search and copy files from one location to another based on the list given in excel sheet us nmkhan3010 Excel Programming 2 09-07-2020 10:27 AM
Do I need a power query for this one? shabbaranks Excel 5 04-10-2019 03:29 AM
Query and Power Query not working Excel 2016 bl10 Excel 0 07-22-2016 06:25 PM
list folders and files using .vbs file josianne Excel Programming 3 08-18-2014 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft