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


OzGrid Business Applications

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

Re to 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.