Select Folder - Simples Method

A

Andibevan

What is the best method to allow the user to select a folder?

Is there an equivalent of the .GetOpenFilename function for Folders? or do
you use this method then remove the selected filename from the string?
 
A

Andibevan

Any chance you provide a couple more lines of code as an example?

application.FileDialog(msoFileDialogFolderPicker).Show
 
A

Andibevan

Thanks Bob - I had missed the fact that your code included part of galimi's.

The problem is that I need to use this code on Excel 2000. I have a
function I found that can be used to Get a Folder name but it involves a lot
of code and it seemed logical that there would be a simpler way.

Obviously this is only true from XP onwards.

Thanks

Andi


see my response
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Folder - Simples Method 3
Open Workbook Question 1
Dialog box for user to select a folder 6
How do I Get a String... or any variable for that matter? 7
GetOpenFilename - Prevent delete 1
directory structure in VBA form. 5
Reading from a file 1
Downgrading from Windows 11 1

Top