![]() |
Navigation Tree
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 |
Navigation Tree
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 |
Navigation Tree
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 |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com