Map Network Drive

L

leerem

Hi All,
I need to Map Network to 12 different sites PC's ,around the
country. At present I'm doing this manually and after my routine has run I
manually Disconnect from each site otherwise it slows down the PC, especailly
when opening or closing a workbook.
Can this be done programatically. for example I have a site in say belfast
whose ID No. is \\bft-123456w\d$ D drive being the drive in question that
needs to be accessed. on some of the sites this also requires a User name and
Password. Does anyone have and idea on how the code should be written to
accomplish this.

Many regards
Lee
 
G

Gary''s Student

Create a file called leerem.bat containing the following three lines:

net use d: /delete /y
net use d: "\\bft-123456w\d$" /PERSISTENT:yes
pause

Then execute the .bat file
 
D

Dave Peterson

Just curious why you can't access files on that network share by using the UNC
path (not the mapped drive).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Map Network Drive FAO Gary's Student 4
Macro to Map Network Drive 1
using a macro to map a drive 2
Check and map Network drive 6
Map drive to open a file with code 4
Map to a network drive 4
e-mail with link to folder on network drive 2
Linking to tables through a mapped VPN drive. 1

Top