View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pk pk is offline
external usenet poster
 
Posts: 4
Default Folder picker: default to network share?

Hello, I hope someone can help me please.

I am using the built-in folder picker:

Application.FileDialog(msoFileDialogFolderPicker)

And I would like to have it initially display all of our
network shares along with the local drives. On our
network, this is equivalent to clicking "Computer" which I
think is equivalent to "My Computer".

I know you can name an initial path using:

..InitialFileName = "{my path}"

But I can't seem to get it to default to "computer" or at
least to a listing of the network shares. Does anyone know
how to do this?

Your example code is mostly what I need. Thanks in advance
for your assistance...