Excel VBA - Return the Path Name of a Mapped Drive

[dhancy]

Hello.

I have this code to map a network drive to the W: drive:

Dim MyDriveName As String
    MyDriveName = "[B]https://myPortal.com/sites/blahblahblah[/B]"
    Set MyDrive = CreateObject("WScript.Network")
    MyDrive.MapNetworkDrive "W:", MyDriveName

I now want to write additional code to return the path name that is associated with the W: drive.

I found this code:

Sub ShowDriveInfo()
    Dim fs, d, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    
    Set d = fs.GetDrive(fs.GetDriveName(fs.GetAbsolutePathName("W:")))
    Debug.Print  d.ShareName
    
End Sub

But t returns this:

\\myPortal.com@SSL\DavWWWRoot\sites\blahblahblah

Is there similar code that will return https://myPortal.com/sites/blahblahblah instead?

Thanks!


Dennis

 

[Zot]

Hello.

I have this code to map a network drive to the W: drive:

Dim MyDriveName As String
    MyDriveName = "[B]https://myPortal.com/sites/blahblahblah[/B]"
    Set MyDrive = CreateObject("WScript.Network")
    MyDrive.MapNetworkDrive "W:", MyDriveName

I now want to write additional code to return the path name that is associated with the W: drive.

I found this code:

Sub ShowDriveInfo()
    Dim fs, d, s
    Set fs = CreateObject("Scripting.FileSystemObject")
   
    Set d = fs.GetDrive(fs.GetDriveName(fs.GetAbsolutePathName("W:")))
    Debug.Print  d.ShareName
   
End Sub

But t returns this:

\\myPortal.com@SSL\DavWWWRoot\sites\blahblahblah

Is there similar code that will return https://myPortal.com/sites/blahblahblah instead?

Thanks!


Dennis

Why not just remove the \\ and append the result with https://?

 

[dhancy]

Then I would have:

https://myPortal.com@SSL\DavWWWRoot\sites\blahblahblah

instead of:

https://myPortal.com/sites/blahblahblah;)

I guess my question is - Where did the "@SSL\DavWWWRoot" come from? And why does it have \ instead of / ?

Hmmm...

 

[Zot]

Then I would have:

https://myPortal.com@SSL\DavWWWRoot\sites\blahblahblah

instead of:

https://myPortal.com/sites/blahblahblah;)

I guess my question is - Where did the "@SSL\DavWWWRoot" come from? And why does it have \ instead of / ?

Hmmm...

Sorry I was confused. The forward slash or simply slash is used in URL. For path and directory, the backslash is used. Since the code is to show path, the backslash is the correct notation.

The

https://myPortal.com/sites/blahblahblah

is directing to an IP address once translated by DNS. Not sure how you can map it as drive path.