Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there One & All,
I'm sure that I've seen my problem posted here (and on various sites) before, but I can't seem to get the right terms for a search. I either get no responses, or thousands of them that aren't quite right. My situation is that I'm using Chip Pearson's Browse for Folder code as found on his website. It's working just fine, however it isn't quite doing what I need. The browser works just as expected, but I can't go back up the file system from whatever I've set as a start point. e.g. If I set the default folder as D:\Files\Tests, I can use the browser to go to D:\Files\Tests\July, but not to D:\Files. It wouldn't be a problem except that there's no guarantee my users will be using a constant file setup. They could have their folders named totally arbitrarily and perhaps on other disks. Can someone please point me to a site that explains what to do? I'm sure I've found it somewhere previously, but it's evading me entirely at the moment. Thanks in advance Ken McLennan Qld, Australia |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I set the default folder as D:\Files\Tests, I can use the browser to go
to D:\Files\Tests\July, but not to D:\Files. You have to set the root as high as you want users to be able to go. Perhaps "D:\" in your case. To give them complete freedom pass in zero as the root. -- Jim Rech Excel MVP "Ken McLennan" wrote in message .. . | G'day there One & All, | | I'm sure that I've seen my problem posted here (and on various | sites) before, but I can't seem to get the right terms for a search. I | either get no responses, or thousands of them that aren't quite right. | | My situation is that I'm using Chip Pearson's Browse for Folder | code as found on his website. It's working just fine, however it isn't | quite doing what I need. The browser works just as expected, but I can't | go back up the file system from whatever I've set as a start point. | | e.g. If I set the default folder as D:\Files\Tests, I can use the | browser to go to D:\Files\Tests\July, but not to D:\Files. | | It wouldn't be a problem except that there's no guarantee my users | will be using a constant file setup. They could have their folders named | totally arbitrarily and perhaps on other disks. | | Can someone please point me to a site that explains what to do? | I'm sure I've found it somewhere previously, but it's evading me | entirely at the moment. | | Thanks in advance | Ken McLennan | Qld, Australia |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
G'day there Jim,
You have to set the root as high as you want users to be able to go. Perhaps "D:\" in your case. To give them complete freedom pass in zero as the root. Unfortunately, that's the situation I was trying to avoid. I want to set a 'default' folder for the majority of cases, but still allow those who actually know what they're doing to navigate where they will. A fair proportion of my users don't have a clue, so I need to set the default to the most likely scenario. For those who know enough to set up their systems individually, I need to allow them access to what they want. This could well mean a network drive, or somewhere else on their hard drive. Zero passed in could well be OK for them, but meaningless to some of the others who are just barely literate, let alone computer literate. I'll just keep trying to hunt around I guess. Thanks anyway. See ya Ken McLenan Qld, Australia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Decision tree | Excel Worksheet Functions | |||
Decision Tree Add-In? | Excel Worksheet Functions | |||
tree chart | Charts and Charting in Excel | |||
Family tree | Excel Discussion (Misc queries) | |||
tree view | Excel Programming |