How to Open a folder in windows explorer with Excel vba

[Turbo613]

I'm sure this is really easy, but I'm learning and not having luck in the search option for previous posts. Thanks for your patience in advance.

I want to open a windows explorer window by using a button in Excel.

Any ideas?

Thanks Turbo!

 

[Turbo613]

Cool, you are very helpful and I appreciate your fast response.

Is there a way to maximize the window once it opens and then

re-focus on the a1 cell of the original excel workbook?

 

[Datsmart]

/n, - Opens a new Explorer window
/e, - Opens expanded folder

Still looking for a way to maximize the window when opening.

Anyone else?

 

[Turbo613]

Perfect! thanks very much.

 

[Ivan F Moala]

/n, - Opens a new Explorer window
/e, - Opens expanded folder

Still looking for a way to maximize the window when opening.

Anyone else?

It's not a part of the switch, rather a part of the Shell functionality you supplied


Constant Value Description
vbHide = 0 Window is hidden and focus is passed to the hidden window. The vbHide constant is not applicable on Macintosh platforms.
vbNormalFocus = 1 Window has focus and is restored to its original size and position.
vbMinimizedFocus = 2 Window is displayed as an icon with focus.
vbMaximizedFocus = 3 Window is maximized with focus.
vbNormalNoFocus = 4 Window is restored to its most recent size and position. The currently active window remains active.
vbMinimizedNoFocus = 6 Window is displayed as an icon. The currently active window remains active.