Question:
Is there a way to get a list of folders for a network drive passing in the server name(for example, \NetDrive). I tried using Dir(“\NetDrive”,vbDirectory) but received only an empty string.
Answer:
You must give both the server name and the share name for this to work, for example:
dir \ServerNameShareName*.*
Note that the sharename can either be an explicit share, or one of the hidden default shares, like c$ (assuming that you have rights to these shares, which are usually only for admin-equivalent users).