+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    KymY
    Guest

    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. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    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
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1