Quote:
Originally Posted by p45cal
|
Thanks, p45cal, I can see that would work, but since I have no other current use for Power BI, I would be installing it for a single use.
What I'd been using thus far is a Powershell command
Code:
dir -n > dirlist.txt
, which works for my purpose, except for having to import the resulting text into Excel and then do a separate parsing to get only the Project number in a separate column next to the full name. Thought maybe PQ could do that more readily, and also be refreshed. All things being equal, I will probably just do the PQ and know I'll have a few missing \Invoices\ subfolders when the first invoices come out (due to their being empty).