Connecting to a network drive using VBA
 

Hi,

I would like to call a excel file which is actually stored in a network.
There are two networks which i want to connect, one is controlled by user
account and the other is a open one.

Can anyone please help me to write a code which will either connect to the
network drive by getting the username/password or by anyother way of directly
calling the network folder probably using FileSystemObject library.

Its ok even if it has to connect a drive to the network path. But would be
useful if you tell me how to remove this within the code!!

For Eg: the network path would look like \\10.10.10.10\sharedfolder

Many Thanks
Sri