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.
You must give both the server name and the share name for this to work, for example:
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).