In Office 2002, Application.FileDialog work in all. Use "msoFileDialogFilePicker" to select files to process yourself.
Function GetFilename() As String
With Application.FileDialog(msoFileDialogFilePicker)
.ButtonName = "Save"
.Filters.Clear
.Filters.Add "all", "*.*"
.Filters.Add "text", "*.txt"
.FilterIndex = 2
If .Show = -1 Then
If .SelectedItems.Count > 0 Then
s = .SelectedItems(1)
GetFilename = s
End If
End If
End With
End Function