ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Navigation Tree (https://www.excelbanter.com/excel-programming/307044-navigation-tree.html)

Ken McLennan[_3_]

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

Jim Rech

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



Ken McLennan[_3_]

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