Move all files in a folder to sub-folder when folder is selected

[capson]

I download xlsx files from an app to a folder, is there a method that would move all files in a folder to subfolder when the parent folder is selected or is it possible to run a macro when a folder is selected

I have searched but found nothing

Thanks

 

[John_w]

I don't think it is possible to run a macro when a folder (in Windows File Explorer) is selected.

You could create a WMI (Windows Management Instrumentation) script which monitors a specific folder for any files placed in it and moves them to a subfolder. The script can be written in VBA, VBScript or PowerShell. Search for "WMI monitor folder" for examples.

 

[capson]

John thanks, I did not think this was possible but thought I would ask