Quote:
Originally Posted by kilroyscarnival
it's been "refreshing" for about 40 minutes.
<snip>
If I have to give up on it now, I may set it to refresh while I'm gone overnight and see if I get results.
<snip>
It's still taking a very long time to load.
|
How extensive are the folders below FPath?
Are we talking urls, sharepoint, or just the local hard drive?
Maybe, just perhaps… see here:
Credentials problem | Excelguru Forums
Quote:
Originally Posted by kilroyscarnival
I want to see if I can further filter after your results come through to show only the folder paths that end in *Invoices. I don't think there's a way to use a variable in the A1 path like \projects\*\*Invoices, is there? The first * would be the project folder file name, and the second * would be anything that came before Invoices, in some cases a folder number like "2. Invoices".
|
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.
02-22-2023, 04:06 PM
Similar Threads
Power Query to get a list of folders (not files) in a location?
Windows 10 
Office 2019
Threaded Mode