Srinath.. following works for me:

Sub UseFileDialogOpen()
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.InitialFileName = "c:\"
.FilterIndex = 2 'excel files
.Show
If .SelectedItems.Count = 1 Then Workbooks.Open .SelectedItems(1)
End With
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Srinath" wrote:

Hello ,

I would like to know how i can give a Default Path (say
c:\xxxx\yyyy\zzzz) when using GetopenFilename. Is this possible or is
there any other method to do the same?
I'm using Excel 97

Regards,
SSR