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. |
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