Inserting multiple explorer windows into a spreadsheet

  • Thread starter Thread starter Michelle Hillard
  • Start date Start date
M

Michelle Hillard

Hi guys,
This is probably a really silly question.
But, is it possible to embed some kind of control that allows you to click
on a cell or command button and have an explorer type window appear with
just the dimensions you want, and navigates to a particular path? Could you
then navigate through that explorer window while the spreadsheet is still
viewable, that is, no other dimensions change (not the explorer window or
spreadsheet).

For example, on worksheet 'Sheet1',

Could you insert:
A command button eg.in cell A2, and in range B2:H15 have an explorer window
that points to eg.C:\reports
If there exists subfolders in C:\reports, and I click on one of them in the
explorer window, it navigates to that folder while I can still see the rest
of my spreadsheet.


A command button eg.in cell L2, and in range M2:T15 have an explorer window
that points to eg.C:\documents

Any help greatly appreciated.

Simon

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
 
Hi Michelle

You can open a folder like this

Sub test()
Shell "explorer.exe C:\Dell", vbNormalFocus
End Sub

If te size of the explorer window is not to big you can see your worksheet

But tell us what you want to do.
If you want to open a file there are other solutions
 
Back
Top