View Single Post
  #1 (permalink)  
Old October 26th, 2007, 09:39 PM
bab02 bab02 is offline
Authorized User
 
Join Date: Jul 2004
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need path from Open dialog box call

Is there a way to read the path from the Open dialog box once a user navigate to a file? Using the code below:

' Display the Open dialog box and allow a user to select multiple files to open.
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog(FileDialogType:=msoFileDial ogOpen)
With dlgOpen
    .AllowMultiSelect = True
    .Show
End With

Thanks


Reply With Quote