Excel 2003 VB code needs to run in Excel 2000

[AndrewE]

Hi
This VB code below runs fine in Excel 2003 under an object in a form and the file browser window opens nicely, allowing the navigation to and selection of a file. However, I need to have the same functionality running in an Excel 2000 environment. The problem is that this version of Excel does not recognize the 'msoFileDialogOpen' argument.

The user cannot at this stage move to 2003.

Please let me have some ide how to achieve the same look and function in the Excel 2000 environment. Your help is really appreciated. AndrewE

'------------------------------------------------------
' Open the file dialog to select a file
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
FirstFileName = .SelectedItems(1)
Workbooks.Open (.SelectedItems(1))
End With