ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Folder picker: default to network share? (https://www.excelbanter.com/excel-programming/279322-folder-picker-default-network-share.html)

pk

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...


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com