Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 90
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 90
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decision tree Mickeddie Excel Worksheet Functions 4 February 13th 12 10:12 AM
Decision Tree Add-In? Lon Excel Worksheet Functions 4 February 10th 12 06:52 AM
tree chart Quant Charts and Charting in Excel 0 March 5th 07 02:44 PM
Family tree TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 September 27th 05 07:33 PM
tree view Stewart Rogers Excel Programming 1 July 22nd 04 12:58 PM


All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"