Help required in file diaolog folders

[arunmd1]

Hi guys,
Now the following is the code that i used to get the path of the folder that the users selects by browsing. It is workin fine in Excel 2003. But it is not in 2000. Can u suggest a solution ?

'Open the folder dialog
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
.Show
End With

fldr = Application.FileDialogmsoFileDialogFolderPicker).SelectedItems(1)

 

[PHV]

Have a look here:
thread707-1414751

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[arunmd1]

Hi PHV,
But if i use browseforfolder option , it is not allowing the user to go above the starting path.Or we have to give nothing as starting path. In this case the user has to go thru the whole folder structure to select his folder. And one more thing it is also not remembering the path of the last chosen file every time.

But my above snippet does that.