View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
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