how to search from windows 7 an excell sheet

hi
i have windows 7 , 32 bit - Microsoft office 10
i design one exec ll sheet , but i lost it now
i fail to search about it
because i forgot its name also
but i'm still remember sheet names , or sheet content
any way to search for that file by sheet name or by content ?
NiceMan331Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
If you want to search for data in the worksheet then

to look for abc type

content:abc

in the search bar.

If it is a phrase like            From abc to def

Content:"From abc to def"

I am not sure if you can look for sheet names in this way.
0
NiceMan331Author Commented:
sorry , i didn't understand your comment
you mean i can type content of the workbook in the search bar ?
0
Saqib Husain, SyedEngineerCommented:
Yes, you type in the search bar; including the word content with a colon and no space after it.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Or open MyComputer and in the search box type *.xl
This will show you all the excel files saved on your computer.
Now just below the search box and left to help icon (? question mark), you will see a icon which is used to show the preview pane, click this to enable the preview pane.

Now if you select the search results, on the preview pane you will be able to see the sheet names and the sheet contents.

That is the possible way to located a saved excel file in this case.
0
BillDLCommented:
Do you normally save your Excel files as the default *.XLSX extension, or as the older "office 97 to 2003" *.XLS for backward compatibility?

If you normally save as *.XLS, then the names of the worksheets are in plain text and could easily be found using a FIND command from the command prompt.  For example, if you knew that one of the worksheets in your lost Excel file was named "Accounts August", you could use a command something like this to find XLS files containing a worksheet with "August" or "august" in the name:

for /r "C:\Users\Bill" %%A in (*.xls) do type "%%A" | find /i "August"

If you normally save as *.XLSX, then the names of the sheets are inside separate XML files that are zipped up into the single XLSX file, and cannot be searched for using the FIND command from the command prompt.  You would have to use another method.
0
BillDLCommented:
Thank you Niceman331
0
NiceMan331Author Commented:
thanx to you too
just for a clarification
i should use all this sentence as it is ?
for /r "C:\Users\Bill" %%A in (*.xls) do type "%%A" | find /i "August"
0
BillDLCommented:
No, it was just an example.  You would replace the "C:\Users\Bill" with the path of the main folder in which you expect to have all your XLS files saved.  You would obviously use your own search word where "August" is shown.

If you use the command on its own, then you should only use %A.  If the command was part of a batch file you would use %%A.

I actually forgot to have the command tell you what XLS file the search word was found within.

Here is a batch file that should work if you put your own folder path and file name into lines 2 and 3 only after the = sign.

Copy the text below, paste into Notepad, change the parts after the = sign in lines 2 and 3, and save as something like "SearchXLS.cmd".  Be sure to include the .CMD at the end of the file name or it will just tave as a .txt file.  Save it anywhere.  Double-Click to run the batch file.  It will save a report to the same folder as specified by you against line 2 giving you the full paths to XLS files containing the search word you specified after the = sign in line 3.

@echo off
set TopFolder=C:\Your_Folder_Path
set SearchWord=YourSearchWord

set ReportFile=%TopFolder%\search_report.txt
if exist "%ReportFile%" del "%ReportFile%">nul

echo Searching XLS files for word "%SearchWord% ...

for /r "%TopFolder%" %%A in (*.xls) do (
    echo Searching: "%%A" ...
    type "%%A" | find /i "Confidential"
    if not errorlevel 1 echo %%A>>"%ReportFile%"
)

echo.
echo Finished Search.
echo.
pause

Open in new window


If for some reason it doesn't work, then it won't damage or change any files.  It just searches them and creates a report file.
0
NiceMan331Author Commented:
yes
i do like this :

@echo off
set TopFolder=e:\b_shops\Downloded_Files\Employee
set SearchWord=Incentive

set ReportFile=%TopFolder%\search_report.txt
if exist "%ReportFile%" del "%ReportFile%">nul

echo Searching XLS files for word "%SearchWord% ...

for /r "%TopFolder%" %%A in (*.xls) do (
    echo Searching: "%%A" ...
    type "%%A" | find /i "Confidential"
    if not errorlevel 1 echo %%A>>"%ReportFile%"
)

echo.
echo Finished Search.
echo.
pause

Open in new window



for this statement
set SearchWord=Isheet1
i used first the excell sheet name "sheet1"
then the command not created the searched.txt
again i edited to put the file name , "incentive"
also not created the txt file
0
NiceMan331Author Commented:
Bildel
please respond to my last comment
i feel already that i have great help from you
i request to open the question in purpose of re distribute the point
please continue
thanx in advance
0
BillDLCommented:
Sorry.  I have been off work with an injury that means I cannot sit for very long.

First of all, check your spelling of "Downloded_Files".  Should it be "Downloaded_Files"?

Secondly (this was my mistake), in line 12 of the code you posted, I forgot to change the search term that I originally used to test the batch file.  That line should be:

    type "%%A" | find /i "%SearchWord%"

You have already have the line;
set SearchWord=Incentive
so anywhere else in the batch file you can use the variable %SearchWord% and it will be expanded to "Incentive".

Remember, this will ONLY work for XLS files, NOT XLSX files.

If that batch file still doesn't work for you, try this one.  Note that I have changed "Downloded" to "Downloaded".  Change it back if it was already correct for you.

@echo off
SetLocal EnableDelayedExpansion

set TopFolder=e:\b_shops\Downloaded_Files\Employee
set SearchWord=Incentive

set ReportFile=%TopFolder%\search_report.txt
if exist "%ReportFile%" del "%ReportFile%">nul

echo Searching XLS files for word "%SearchWord% ...
echo Search folders from: %TopFolder%>"%ReportFile%"
echo Search Term used: %SearchWord%>>"%ReportFile%"

for /r "%TopFolder%" %%A in (*.xls) do (
    set XLSFile=%%A
    echo Searching: "!XLSFile!" ...
    type "!XLSFile!" | find /i "%SearchWord%"
    if not errorlevel 1 echo "!XLSFile!">>"%ReportFile%"
)

echo.
echo Finished Search.
echo.
pause

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@ Bill
Sorry.  I have been off work with an injury that means I cannot sit for very long.

Being an EE members, we all are concerned about you. What happened to you?
We hope that you will recover from your injury soon and don't forget to take proper rest.

Please get well soon.

sktneer
0
BillDLCommented:
Thanks for your concern sktneer.  I ripped the ligaments in my knee in a fall at work, and have my leg in a stiff brace, hence the inability to sit down for long.  My comment above probably sounded like I had injured my bum and couldn't sit down.  It should heal up in time.  Any errors in my post can be blamed on the strong painkillers ;)
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Knee ligaments are very sensitive and you really need to be very careful about it as it involves internal swelling and that must be subsidized completely with the help of medication and rest before you are back to your normal routine.

Consider taking Flax Seeds on regular basis, that would help you to heal fast and it will also provide sufficient lubrication necessary for the ligaments.

Take Care.
0
NiceMan331Author Commented:
thanx ebidl
and sorry for your inury
i didn't know what happened to you
i'm so sorry
take care please
in other hand , the code now works perfectly
but i would like to say that it is yes not working with xlsx as you said
but i tryied to searched word : "sheet" which is usally the sheet names in default
the text file return back all sheets names even under xlsx file format
but for any other searched word , it return only the one with xls format
thanx again
0
NiceMan331Author Commented:
thanx very much , actually it is ok for me regarding xls file , the solution of ebildl is great
remaining now if it is xlxs format
thanx alot
0
dew_associatesCommented:
Are there any unique titles or names in any of the cells of this excel document?
0
NiceMan331Author Commented:
no , they are probably having different names
0
dew_associatesCommented:
okay, let me ask this a different way. Is there 1 name in any one of the cells?
0
NiceMan331Author Commented:
if i understood your question , you may asking if the sheet name is unique in each file ? the answer is no
the sheet name may be found in one or more than one file
0
dew_associatesCommented:
What I asked you was are there any names or titles in the cells of this lost excel document.
0
NiceMan331Author Commented:
actually my file found with the code of ebitil , but that one works only with xls format
i'm asking in general about if the format is xlsx
and if you mean a name inside the sheet , yes there is , but not necessary all sheets has names or titles
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
actually my file found with the code of ebitil , but that one works only with xls format
i'm asking in general about if the format is xlsx

Are you referring to the code I provided in your following question? If so, that's not true, the code will search for all the Excel Files i.e. .xls, .xlsx and .xlsm
Isn't it so?

http://www.experts-exchange.com/questions/28710204/displaying-all-esxcell-files-with-their-sheets-name.html
0
BillDLCommented:
No, I think NiceMan331 was referring to the simple batch file that I posted earlier that only finds the matching search term in the text-based contents of an *.XLS file, but will not work for the zip format of *.XLSX.  I noticed earlier that he had addressed me a couple of times as "ebidl".  I assumed it was a typo, as with "ebitil".
0
NiceMan331Author Commented:
No, I think NiceMan331 was referring to the simple batch file that I posted earlier

exactly

and sorry for mis_name you mr Billdl
and how is your knee now  ?
0
BillDLCommented:
No problem NiceMan331.  I have been called a lot of things over the years ;-)
Knee is less painful now and I can walk with a knee brace and crutch now.  Thanks.
0
NiceMan331Author Commented:
TAKE CARE PLEASE
thanx alot for your full help
0
dew_associatesCommented:
Okay, for the moment, let's suppose that one of the cells of your excel document has NiceMan331 in the cell. The number of attaching sheets is irrelevant.

In Windows 7, click the start button and in the "Search programs and files" box, type in NiceMan331 and then touch entire. Every document that has NiceMan331 somewhere in that document will come up in a search window.
0
BillDLCommented:
Thank you NiceMan331
0
NiceMan331Author Commented:
You are welcome mr ebidl
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.