[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Network Drive Mapping

I'm setting up a small bit of VBA Code to map a network drive if the path isn't available and i've got that to work but the mapping is showing up as
blank on 'UNC PATH'

rather then the usual
folder on 'UNC PATH'

is there anyway to fix that here is an example of the code

    Set wshNetwork = CreateObject("WScript.Network")
    Set colNetDrives = wshNetwork.EnumNetworkDrives
   
    For X = 71 To 90 'Letters G through Z
        DrvFound = False
   
        For Y = 1 To colNetDrives.Count - 1
            If colNetDrives.Item(Y) = Chr(X) & ":" Then
                DrvFound = True
            End If
        Next Y
       
        If Not DrvFound Then
            strDriveLtr = Chr(X) & ":"
            Exit For
        End If
    Next X
   
    wshNetwork.MapNetworkDrive strDriveLtr, sDRIVEMAPPING, True

End Sub
0
Thrawn3000
Asked:
Thrawn3000
  • 3
1 Solution
 
Jackie ManCommented:
Run a ipconfig /all in command prompt and post back the results.
0
 
Kody-BurgCommented:
Not entirely sure what you are asking, but I don't see anything in your code that actually tells the system where to map the drive to. You can do that with the following code:

Set objNetwork = CreateObject("WScript.Network")
objNetwork.MapNetworkDrive "K:", "\\SERVERNAME\FOLDER"
                                               ^                           ^
                                          Drive Letter           Folder Location
0
 
Thrawn3000Author Commented:
Ok could better explain what i'm asking,

say i have the following UNC pathname

\\SERVER\FOLDER1\FOLDER2\FOLDER3\

When mapped manually through the 'Map Network Drive..' feature in windows XP it becomes

FOLDER3 on '\\SERVER\FOLDER1\FOLDER2'

when i use the code

wshNetwork.MapNetworkDrive strDriveLtr, sDRIVEMAPPING, True

strDriveLtr = the drive letter i'm assigning the map to
sDRIVEMAPPING = the UNC pathname

it comes up

 on \\SERVER\FOLDER1\FOLDER2\FOLDER3\

instead
0
 
Jackie ManCommented:
The UNC path should be \\SERVER\FOLDER1\FOLDER2\FOLDER3 instead of \\SERVER\FOLDER1\FOLDER2\FOLDER3\
0
 
Jackie ManCommented:
You add an additional "\" after the UNC path.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now