ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel - Use Windows Explorer instead of File Open to open file (https://www.excelbanter.com/excel-discussion-misc-queries/103321-excel-use-windows-explorer-instead-file-open-open-file.html)

KymY

In Excel - Use Windows Explorer instead of File Open to open file
 
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.

raypayette

In Excel - Use Windows Explorer instead of File Open to open file
 

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



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

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