| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transformar nĂºmero simples em datas correntes | Excel Discussion (Misc queries) | |||
| How to decide folder-depth or How to select more folders/subfolders (folder-tree) ? | Excel Discussion (Misc queries) | |||
| allow user to select folder | Excel Discussion (Misc queries) | |||
| Select Method of Sheets | Excel Programming | |||
| Help with Select Case or Best Method | Excel Programming | |||
![Andibevan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
