Drive List with Mapped Network Drives and My Network Places

You might find the common dialog control a bit easier.

I use this function in a form with the control on it.

Public Function FileBrowse(Message As String, Expectedpath As String, DefaultName As String, FilePattern As String, Save As Boolean) As String
Dim NewFileName As String
    On Error GoTo FileBrowseError
    Me.CommonDialog1.CancelError = True
    Me.CommonDialog1.FileName = DefaultName
    Me.CommonDialog1.InitDir = Expectedpath
    Me.CommonDialog1.DialogTitle = App.Title & " - " & Message
    Me.CommonDialog1.FilterIndex = 1
    Me.CommonDialog1.Filter = FilePattern
    If Save Then
        Me.CommonDialog1.Flags = 0 Or cdlOFNHideReadOnly
        Me.CommonDialog1.ShowOpen
    Else
        Me.CommonDialog1.Flags = 0 Or cdlOFNFileMustExist Or cdlOFNHideReadOnly Or cdlOFNReadOnly
        Me.CommonDialog1.ShowOpen
    End If
    FileBrowse = Me.CommonDialog1.FileName
FileBrowseError:
    Exit Function
End Function

Hi tristan256,
This old question (QID 20560666) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
[Accept Cimperiali's comment as Answer]
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

[Sethi]
EE Cleanup Volunteer

Let me suggest to split points with GrahamSkan, as also his answer is a solution that can work.
Cesare Imperiali

Thank you Cesare. If I were cleaning up, I'd have made the same recommendation that Sethi did. You were the first to give a viable solution, and there are only 50 points to split. But it's nice to be recognised
Graham

;-)
Have a nice day, Graham

Cesare