need a script to take a DIR list to XLSX
i've posted here too:
Macro to list Directories in various location - per worksheet
but basically i would like a script/macro that takes the directory listings of variou server shares and put them in one excel spreadsheet i can then search through - an index if you like.
has anyone got anything, or know of a way?
thanks, still a couple of issues
thanks LosOjos - very nice, but it only gets the last item in the folder - and its getting files, rather that just folders. (so the XLSX file just had one line, with an MSI file in A1, despite there being 50+ folders).
also the output is saved in the remote location, not the local location of where i am running the script from (C:\)
any pointers would be greatly appreciated!