Macro to Map Network Drive

[Dave]

Hello

I work remotely and have to map my network drives on a daily basis. Is
there a macro I can create that will allow me to map network drives?
Currently, I have to go into Windows Explorer --> Tools --> Map Network Drive
and map the drives "manually". I have to enter the following information:

Drive Letter: S
Folder: \\###.##.###.##\aaaaa$

Then I have to go into "Connect using different user name" and enter:
user name: \\companyname\"myuserID"
password: xxxxxxxxxx

Any help is appreciated.
Thanks

 

[JLatham]

Best way to do it is with a VB Script file so you don't have to depend on
Excel.

On this page:
http://visualbasic.ittoolbox.com/documents/vbscript-to-map-network-drive-11821
you'll find the basic outline for such a script that you can modify. I
didn't test it, so YMMV. But a search for "vb script to map network drive"
will provide lots of other examples.

Simply use a text editor like Notepad to create a file, save it somewhere
with a .vbs filename extension, then put a link (shortcut) to that file in
your 'Startup' folder.