Directories ans Drive Controls in Excel VBA

[chateaucl]

I am trying to use directories and drive control to make a file selection form in a Excel application, but i can't find those control in excel vba toolbar. I looked in 'Aditional Controls', but i don't know how to set them.

I am using Excel XP. I also have installed Visual Basic 6.0.


Thanks.

 

[byundt]

Here are three ways to display a browse window so the user can pick a file:

Sub PickFile()
Dim flPath As String
    'Can specify starting directory but must click "Save" button in somewhat confusing fashion. Open file separately.
'flPath = Application.GetSaveAsFilename(InitialFileName:="C:\VBA\")

    'May browse to find file, then click "Open" button. Open file separately.
'flPath = Application.GetOpenFilename

'If flPath <> "False" Then Workbooks.Open flPath

    'Display the File Open dialog. File will be opened when you click the Open button
Application.Dialogs(xlDialogOpen).Show
End Sub