MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Drivelist and directorylist


Posted by amroo on April 12, 2001 11:21 PM

Bonjour, I want to put on my userform a directorylist and drivelist but I don't find them in the tools.
Where are they, on a VB form I can do that.
2001 merci.
Amroo from Nancy-France


Posted by Dave Hawley on April 13, 2001 3:09 AM


Hi Amroo

I would use the bulit the GetOpenFilename, this will show the open dialog and pass back the choice as a String.


Private Sub CommandButton1_Click()
Dim SFileandPath As String
SFileandPath = Application.GetOpenFilename
If SFileandPath = "False" Then Exit Sub
MsgBox SFileandPath
End Sub


Dave


OzGrid Business Applications

Posted by amroo on April 13, 2001 4:44 AM

Re to Dave

Dave,
Thank you for your help , so it runs but I want to get the file path selected into a macro for opening a selected file text using your solution
2001 regards.
Amroo