help required in folder picker option

[arunmd1]

Hi ,
Now my requirement is , i should allow the user to select only a folder browsing thru a dialog box. I cannot use Browseforfolder since it doesnot provide the option to go back behind the starting path and also it doesnt remember the path of the last selected folder. I can use folderpicker option but it is not compatible for me since i am using excel 2000. Any other solution for this ?

 

[MajP]

Use an API solution. There are several out there.

http://databaseadvisors.com/pipermail/accessd/2004-January/018319.html

http://www.cpearson.com/excel/BrowseFolder.aspx