macro that will list all the filenames (including their creation date, modification date, hyperlink file path) in all the folders and sub-folders of a

[papajups]

Good day All,


Hope all is well.

I humbly ask for your assistance, and help me have a macro that will list all the filenames (including their creation date, modification date, hyperlink file path) in all the folders and sub-folders of the below directory:

O:\ITSC\RSG


I would greatly appreciate your assistance on this matter.


regards,
Papajups

 

[Fennek]

Hi,

the easy way is to go back to the time before windows:

cmd:>dir o:\itsc\rsg\*.* /s/b > c:\temp\myList.txt

It is possible to use this command in a vba-macro, but I hesitate to copy.

regards

 

[papajups]

Good day Fennek,


Thank you for your response.

Could you please tell me how I can run this code?

[COLOR=#333333]cmd:>dir o:\itsc\rsg\*.* /s/b > c:\temp\myList.txt[/COLOR]

Appreciate your help.


regards,

Papajups

 

[Fennek]

Hi,

well, I have forgotton the English wording:

Right-click on the windows-button in the task-row. Then you see something like "run", "execute" or "Powershell". This should either open a shell directly or, if an input-box, type "cmd.exe".

In the "black window" type the code from my previous post.

(c:\temp must exist)

regards