Network Connection: Word / Win 2000 (Word 97)

[richardbarrett]

There's a documented bug in Windows 2000 which causes problems with Print to File when the drive letter of the output file path is a mapped network drive. To resolve the problem, I need to convert the specified drive letter to its UNC value. I understand there's a function called wGetNetConnection (or something similar to that), but I can't find any info on it. I want to pass a drive letter to a function and have it return the UNC value for the network connection.

Thanks,
Richard Barrett

[jscher2000]

If you don't find the Windows function, you can do this:
<pre>Function GetShareFromDriveLetter(strDriveLetter As String) As String
' Jefferson Scher 2-7-02
' This requires a reference to the Microsoft Scripting Runtime
' Access the Drive object through the FileSystemObject
Dim oFSO As New FileSystemObject
On Error Resume Next
GetShareFromDriveLetter = oFSO.Drives(strDriveLetter).ShareName
If Err.Number <> 0 Then
' Most likely, the letter is not mapped or media was removed
GetShareFromDriveLetter = vbNullString
End If
Set oFSO = Nothing
End Function</pre>

[richardbarrett]

Thanks very much. I'll give this a try.

Richard