How I can view sheets from an excel file without open it?

Question

I want to search quickly a sheet in a folder populated with a huge number of excel files.

I try to find a way to build a list(directory) of sheets included in excel files from a specific folder.

Answer 1

You can do what you want to do, but you need a macro code that will open the files, look at the worksheets in it and then close them. It can happen fast enough that they won't appear to be open, but here is some code you need to get the names of the worksheets:
Set up a loop that goes through index numbers 1 to the maximum number of worksheets in the workbook. Select each one using this line of code:
Sheets(WorkSheetNumber).Select

You can capture the name of the worksheet with this line of code:
WorkSheetName = ActiveSheet.Name

You may want to set up a blank sheet that deposits the name into a cell and then moves to the next cell. I suggest you grab the filename too and put in somewhere along with the worksheet name.

Answer 2

If you have Windows 2000 or XP and have the Indexing service turned on, a simple right click on the folder and Search option would allow you to search all the excel sheets for the text you want. Just make sure you enter the search string in the "A word or phrase in the file" textbox in the Search Dialog.

Answer 3

use excel viewer like word viewer

better then load all the whole app

Answer 4

you should try this, i made a short tutorial on how you do it. i'm sure you'll find what you are looking for ;)
http://img216.imageshack.us/img216/132/tutxi7.jpg