View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philipp Oberleitner Philipp Oberleitner is offline
external usenet poster
 
Posts: 14
Default FileServer with GetOpenFilename

Here my code :

Public fName As String
Sub Auto_Open()
ChDrive "\\Mchh227a\FS000458\"
ChDir "\\Mchh227a\FS000458\TS B\TS B 2 (MD MM pWLAN
SAM)\IntegrationProjects\# Templates\ServiceBlueprints\SLA Violation
Radar\Actis Scan"
fName = Application.GetOpenFilename
'MsgBox fName
End Sub


Is it possible to use a Fileserver instead of a drive letter ? If not how
can i integrate so he can open directories on FileServer ?

Thanks alot in advance