File Browser

Baapi


For your future reference I suggest you try the Help File 1st

Never having used Application.FileDialog(msoFileDialogOpen) I placed my cursor at the end of FileDialog pressed F1 and got all the help that required to get you on your way

This code is from the Help file

Sub UseFileDialogOpen()

Dim lngCount As Long

' Open the file dialog
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = True
.Show

' Display paths of each file selected
For lngCount = 1 To .SelectedItems.Count
MsgBox .SelectedItems(lngCount)
Next lngCount

End With

End Sub

As I understand it, the FileDialog object is only available with Office 2002 and above. As an alternative there is the GetOpenFilename Method to display an Open dialog box.

Please Login or Register  to view this content.

Baapi

As I have Office 2003 I did not realize it was not available in 2000