I'd like to use the tree-view window that Windows Explorer displays when
opening files in Exel, rather than having to run up and down the folders
ladder when opening files in Excel.

Is there any way Excel can be trained to use the Win Explorer dialogue box,
instead of File-Open, when opening files ? I never use the clunky My Docs /
My Computer etc buttons in File-Open.

Like many professional Excel users, I access many folders and files every
day and have found it faster to use Win Explorer instead to access my files,
at the cost of not havin them show up in the "most recent files" list in
Excel's File menu.

I would create a macro with a shortcut such as Ctrl+e.
I would erase the code and replace it with:
Shell "C:/WINNT/explorer.exe", vbNormalFocus


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=568584