Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Map Network Drive
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to Map Network Drive
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/doc...rk-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. "Dave" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Map Network Drive | Excel Discussion (Misc queries) | |||
Excel in macro and connecting to a network drive question | Excel Discussion (Misc queries) | |||
map network drive | Excel Discussion (Misc queries) | |||
Multi-user macro on network drive? | Excel Discussion (Misc queries) | |||
Link workbooks-C drive to network drive | Excel Worksheet Functions |