Hello all, i am using the code below to open a dialog to retrieve a file
and it works great if i name the drive letter, howver i need to put in
the server IP, as not all users log the drive on the same letter. The
path enclosed in brackets is the path i need to point to. Could somebody
please help with this code.

Sub TestGet()
ChDrive "c" (" \\zapad01\sapinter ")
ChDir "C:\Documents and Settings\Stoutle\SapWorkDir"
("\\zapad01\sapinter\ZA-TM-RECON\UPLOAD")
fileToOpen = Application _
.GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen < False Then
MsgBox "Open " & fileToOpen
End If
End Sub

Thanks in advance

Tempy

*** Sent via Developersdex http://www.developersdex.com ***