Avi,
The following code will display the File Open dialog and return
the selected file name. It doesn't open the file.
Dim FName As Variant
FName = Application.GetOpenFilename()
If FName = False Then
' no file selected
Else
MsgBox "You chose: " & FName
End If
For other methods of selecting just a folder (not a file), see
http://www.cpearson.com/excel/BrowseFolder.htm
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Avi" wrote in message
...
Hello,
Most of the exemple show how to launch from VBA a dialog to open
a file from a directory.
Is there a dialog that is used to select the file so i can use
its path name in the module, without opening the file?
Regards
Avi
www.avibenita.com