VBA to operate on an external drive + files dispatching in folders

[Frederic]

Hi,

Below is a code sent by mdmackillop which I had some trouble using.
[Code can't be attached because less then 5 post in VBAX]

Please see below my issues once I enter the code.

[Img can't be uploaded because less then 5 post in VBAX]


I really can't figure out how to make this excel run on it's own on the drive. It will always refer to a USB port (e:\ and making it not functional for other user when they plug in the drive.
How can a VBA look up only for an external drive according to it's name instead of looking for a port entry.

This is the USB drive structure

e:\w\
e:\w\files_depository\
e:\w\zip_depository\
e:\w\patched_depository\
e:\w\data_extractor.xlsm

In this case the drive name was "w" but if confusing we can call it (e:\extractor\) which contains the listed above folder and files for your clarity.
See below the value issue due to the USB drive roots.

[Img can't be uploaded because less then 5 post in VBAX]

Thank you in advance for your time and your help !