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
If Not DrvFound Then
strDriveLtr = Chr(X) & ":"
wshNetwork.MapNetworkDrive strDriveLtr, sDRIVEMAPPING, True