Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help required in file diaolog folders

Status
Not open for further replies.

arunmd1

Programmer
Mar 20, 2008
24
FR
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)
 
Have a look here:
thread707-1414751

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top