Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 260
Default Browse For Folder start directory

This question is for Chip Pearson or anyone else who may
know about the Browse for Folder code.

Yesterday Chip Pearson gave me a link to download his
Browse for Folder code on his website. There are 2
versions: 1 that allows you to specify a start directory,
and another that does not.

I am using the one that does allow this. Below is the
code I am using that is inside the browse button click
event:

Dim FName As String
FName = BrowseFolder("Select a folder", "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules")
If FName = "" Then
Else
TextBox2.Value = FName
End If


Heres the problem... It does not allow me to navigate up
levels to prior(higher) directories. It doesnt even allow
me to see any of the other directories accept sub
directories. Eventhough I have started in the "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules" folder, I would still like users
to be able to navigate to a different directory. Is this
possible?



Thanks
Todd Htutenstine
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Browse For Folder start directory

Todd,

You need to use the other one, but that means you start at the root
directory.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
...
This question is for Chip Pearson or anyone else who may
know about the Browse for Folder code.

Yesterday Chip Pearson gave me a link to download his
Browse for Folder code on his website. There are 2
versions: 1 that allows you to specify a start directory,
and another that does not.

I am using the one that does allow this. Below is the
code I am using that is inside the browse button click
event:

Dim FName As String
FName = BrowseFolder("Select a folder", "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules")
If FName = "" Then
Else
TextBox2.Value = FName
End If


Heres the problem... It does not allow me to navigate up
levels to prior(higher) directories. It doesnt even allow
me to see any of the other directories accept sub
directories. Eventhough I have started in the "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules" folder, I would still like users
to be able to navigate to a different directory. Is this
possible?



Thanks
Todd Htutenstine



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 260
Default Browse For Folder start directory

Thanks. I tried using C:\ but that only showed C:\ and
the subdirectories. I used \\ instead and that works.


Todd Huttenstine


-----Original Message-----
Todd,

You need to use the other one, but that means you start

at the root
directory.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine"

wrote in message
...
This question is for Chip Pearson or anyone else who may
know about the Browse for Folder code.

Yesterday Chip Pearson gave me a link to download his
Browse for Folder code on his website. There are 2
versions: 1 that allows you to specify a start

directory,
and another that does not.

I am using the one that does allow this. Below is the
code I am using that is inside the browse button click
event:

Dim FName As String
FName = BrowseFolder("Select a folder", "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules")
If FName = "" Then
Else
TextBox2.Value = FName
End If


Heres the problem... It does not allow me to navigate

up
levels to prior(higher) directories. It doesnt even

allow
me to see any of the other directories accept sub
directories. Eventhough I have started in the "Q:\CS
Management Reports\Reports Setup\Administrator
Files\Exported Modules" folder, I would still like users
to be able to navigate to a different directory. Is

this
possible?



Thanks
Todd Htutenstine



.

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
Save file to same directory folder RobN[_2_] Excel Discussion (Misc queries) 2 April 4th 10 08:06 AM
Browse button on form for folder path Greshter Excel Discussion (Misc queries) 2 January 12th 06 10:20 PM
How to check if a folder/directory exist using VBA wellie Excel Programming 1 March 1st 04 02:24 AM
Designate a folder as the root of the Browse tree kiwichico Excel Programming 0 October 1st 03 10:16 PM


All times are GMT +1. The time now is 05:31 AM.

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

About Us

"It's about Microsoft Excel"