Macro to map a drive (2003)

Topic

New Reply

Hello,

I need to map a network drive and I was wondering if there was a way to do it via excel or not. Basically, they will be selecting drive J and folder testsrv01groupstimesheets. Any help would be great.

Reply | Quote

Replies

This is not really an Excel question, so this thread has been moved to the VB/VBA forum.

Reply | Quote

For example:

CreateObject(“WScript.Network”).MapNetworkDrive “J:”, “testsrv01groupstimesheets”

(Are you sure about that path? There should only be a double backslash at the beginning)

Reply | Quote

Hans,
Can you tell me via which program I can do this? I would like to do it in an excel file or word. By the way, you are correct about the //.

Reply | Quote

The line I posted can be used in a macro in any of the Office applications – Word, Excel, PowerPoint, Access, Outlook.

Reply | Quote

Ok.

Reply | Quote

Hans,

Is there a way to add to the macro a command to put a desktop shortcut for the created map drive J?

Reply | Quote

Also asked (and answered) in post 582,014. This thread is locked to avoid duplication.

Reply | Quote