View Single Post
  #12   Report Post  
Posted to microsoft.public.office.misc,microsoft.public.word.docmanagement,microsoft.public.excel
Gary Smith Gary Smith is offline
external usenet poster
 
Posts: 2
Default How to make the file search to find files by "text or property

Actually as I understand it, the file search function is a separate Office
function that is invoked by Excel, Word, and the other applications, so it
is a generalized external function rather than an application-specific
one. You'll note the the associated help refers to searching for text and
never mentions numbers. Numbers in Excel are normally not text, which is
why the search function cannot find them. However, it's possible to enter
numbers as text in Excel, and those numbers should be searchable.


In microsoft.public.office.misc Dima wrote:
Thanks Gary Smith for your explanation!
The Excel (Office) File search is not an external function. It is called up
from the Excel File menu.
Best regards,
Dima
"Gary Smith" wrote:


The numbers you see when you view a spreadsheet in Excel are not the same
as the data stored in the .xls file. No general search tool will be able
to find such numbers unless is is capable of parsing the .xls file format
and interpreting the contents. That's why you can search for numbers from
withing Excel but not from an external function.


In microsoft.public.office.misc Dima wrote:
Thanks Bob I for your thought!
There is no a "number in Excel", but only "text or property" in the Property
list in the Advanced file search.
Why does not the "text or property" search for a number in the Excel? How to
find an Excel file with the number in its cell then?
Best regards,
Dima
"Bob I" wrote:


Perhaps the text that you are searching for and the "number in Excel"
are not the same thing? They only appear similar to the user?

Dima wrote:

Thanks Bob I for your helping questions!
Yes, the search criteria is being added to the "includes".
It was working before partially. It did not find all files.
I have tried Windows 2000 file search. It did not find the excel file by a
number in its cell too.
Best regards,
Dima
"Bob I" wrote:


I am puzzled as to why it is not finding the file then. Have you tried
several different searches? Is the search criteria being added to the
"includes"? Was it working before?

Dima wrote:


Thanks Bob I for your questions!
Yes, the Location is actually accessible, in NOT a hidden or system folder.
I can browse to those files and open them.
"Bob I" wrote:



Is the Location actually accessible? As in NOT a hidden or system folder?

Dima wrote:



Thanks Bob I for replying.
That goes without saying. I set file types and Search Location also.
Best regards,
Dima
"Bob I" wrote:




You need to Set file types and Search Location also.

Dima wrote:




Hello!
How to make the Office 2003 Advanced file search to find files by the "text
or property"? The Office 2003 sp2 Advanced file search does not find a Word
or Excel file by a word or a number in an excel cell.
Best regards,
Dima
+79035093892






--
Gary L. Smith
Columbus, Ohio


--
Gary L. Smith
Columbus, Ohio