Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 5th 06, 09:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 3
Default 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.

  #2   Report Post  
Old August 5th 06, 09:59 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to Open Excel File Please Help Cole Excel Discussion (Misc queries) 2 July 10th 06 09:04 PM
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 11 February 12th 06 01:38 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
cannot open excel file, please help!!! sunlite Excel Discussion (Misc queries) 0 September 5th 05 05:29 PM
How Do I open an excel file without Excel Viewer support CocoriteBallGiants Excel Discussion (Misc queries) 2 February 4th 05 10:50 PM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017