Select Folder - Simples Method
 

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?

Select Folder - Simples Method
 

application.FileDialog(msoFileDialogFolderPicker). Show
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andibevan" wrote:

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?

Select Folder - Simples Method
 

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

"galimi" wrote in message
...
application.FileDialog(msoFileDialogFolderPicker). Show
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andibevan" wrote:

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?

Select Folder - Simples Method
 

see my response


--
HTH

Bob Phillips

"Andibevan" wrote in message
...
Any chance you provide a couple more lines of code as an example?

"galimi" wrote in message
...
application.FileDialog(msoFileDialogFolderPicker). Show
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andibevan" wrote:

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?

Select Folder - Simples Method
 

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


"Bob Phillips" wrote in message
...
see my response


--
HTH

Bob Phillips

"Andibevan" wrote in message
...
Any chance you provide a couple more lines of code as an example?

"galimi" wrote in message
...
application.FileDialog(msoFileDialogFolderPicker). Show
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andibevan" wrote:

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?

Select Folder - Simples Method
 

I also included the API method for pre-XP systems.

--
HTH

Bob Phillips

"Andibevan" wrote in message
...
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


"Bob Phillips" wrote in message
...
see my response


--
HTH

Bob Phillips

"Andibevan" wrote in
message
...
Any chance you provide a couple more lines of code as an example?

"galimi" wrote in message
...
application.FileDialog(msoFileDialogFolderPicker). Show
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Andibevan" wrote:

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?