how can i have excel open all files auto vs just xls files?

December 16, 2011 at 12:34:48
Specs: Windows Vista
when i open a folder with excel i want it to show all the files in the folder not just excel files

See More: how can i have excel open all files auto vs just xls files?

December 16, 2011 at 12:37:19

Report •

December 17, 2011 at 10:52:00
click on the folder icon and then open the desired folder.

Report •

December 17, 2011 at 12:48:34
What version of Excel do you have?

In 2007, click the Office Button, upper left corner,
Click Open

In the lower right corner there is a drop down menu,
it defaults to: All Excel Files with a list of Excel Extensions following.

Click on it, and select All Files

Other version are similar.


Report •

Related Solutions

December 17, 2011 at 14:30:17

Does it keep that option after you close Excel 2007?

My version of 2010 doesn't. It defaults back to just Excel files the next time I open Excel.

The code below will open the specified folder with all files and folders within it available.

If there's no way to make the "All Files" drop down option remain as the default, the OP could attach this code to a button.

Dim str_folder as string
  str_folder  = "C:\Temp" ' folder to open
   Call shell("explorer.exe " & str_folder,vbNormalFocus)
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

December 17, 2011 at 15:47:24
Does it keep that option after you close Excel 2007?

No, my 2007 reverts back to open Excel Files.


Report •

December 18, 2011 at 11:06:40
i have excel 2007 and once i change it as suggested it does not stay

Report •

Report •

November 19, 2012 at 03:48:30
Hi Derby Dad. Nearly a year on from your post with the macro and it's been found and used successfully! Very strange that Excel doesn't cater for such a basic function, and using the drop down menu a hundred times a day was getting frustrating.

Anyway, the macro works perfectly. I've assigned it to a hotkey and for anyone reading this in the future, I have virtually no knowledge of macros. You just do View - Macros then I gave the macro a single letter name (longer names didn't seem to work) then hit Create. I copy and pasted Derby's code in but then had to delete the 'sub_open folder' and 'end sub' bits because Excel has entered these automatically. You've then got to delete the bit about "C:\Temp" ' folder to open, and replace it with just the location of the file you want to enter, in speechmarks. The try running it and it should open the relevant folder with all files present.

If you want to assign it to a hotkey, come out of the macro designer and then do View - Macro again, select Options and it's straight forward.


Sheffield Dave

Report •

Ask Question