Newbie: Open A Directory 1

[Viz]

Hi All,

I need to have a control open a directory, what command should I use?

Many thanks in advance...
--
Viz

 

[ratman]

Consider this:

ChDir "C:\Inventory Files"
Workbooks.Open FileName:="C:\InventoryFiles\REPORTsf.xls"


If I'm way off let me know:
drat@mediaone.net

 

[Viz]

Thanks for the reply.

I have some controls in an Excel sheet which do various things (open word documents, etc.). I need another control which simply opens a directory.

Any thoughts?
--
Viz

 

[ratman]

Ok.....Condider this:

Application.Dialogs(xlDialogOpen).Show ("C:\My Files&quot


If I'm way off let me know:
drat@mediaone.net

 

[Viz]

Again, many thanks for the reply...

What I would like to do is simply open a folder, rather than use any of the application's dialogs.

The excel spreadsheet has a control which opens a word document which is stored on a network. I need another control (embedded in the spreadsheet) which will simply open a folder into a standard explorer window.

Any thoughts here?

Many thanks.
--
Viz

 

[ratman]

ChDir "C:\Inventory Files"

 

[Viz]

Hi ratman,

This seems only to change the current directory. I eventually played with this and got it to work:

Dim strCMD, RetVal
strCMD = "Explorer.exe \\My_unc\folder"
RetVal = Shell(strCMD, vbNormalFocus)

Kind regards and many thanks.
--
Viz