Opening on memory stick

[mrtim2232]

Morning all,

I've designed a program to open a workbook on a memory stick however currently it has to be plugged into the E: is there any way for the program to detect which port the memory stick is in?

Any help would be appreciated, Thanks in advance

 

[Giordano Bruno]

Why not try to open it in D: and if error then try E: etc.