Prev: how do I save my name as the creater of a workbook
Next: Summing several IF's in a column.
From: deeds on 14 May 2010 11:39
I am trying to do a Windows search to find an Excel file containing a
specific number. I have looked everywhere...no luck. I did the File Search
option within Excel...no luck. There has to be a way to do this...any ideas?
Thanks.
From: Bob I on 14 May 2010 12:42
Are you sure said "specific number" actually exists? A lot of time cell
formatting shows a "view" of a number not the actual number.

deeds wrote:

> I am trying to do a Windows search to find an Excel file containing a
> specific number. I have looked everywhere...no luck. I did the File Search
> option within Excel...no luck. There has to be a way to do this...any ideas?
> Thanks.

From: Ms-Exl-Learner on 14 May 2010 12:48
Start>>Search>>Select All Files and Folders>>All Part of the File Name:>>Type
*.xls OR *.xlsx OR *.xlsb OR *.Xlsm>>A word or phrase in the File>>type the
character or word which is present inside the Excel File>>Lookin>>Select the
Drive if you know it exactly, Otherwise select My Computer from the Drop Down.

* means that the file may contain any name.
*.xls OR *.xlsx OR *.xlsb OR *.xlsm will make the search to go through only
with Excel files other than looking in all files. If you are using Excel 2003
then use the extension as *.xls in All part of the File Name.

--------------------
(Ms-Exl-Learner)
--------------------


"deeds" wrote:

> I am trying to do a Windows search to find an Excel file containing a
> specific number. I have looked everywhere...no luck. I did the File Search
> option within Excel...no luck. There has to be a way to do this...any ideas?
> Thanks.
From: deeds on 14 May 2010 13:18
That does not work. I have a test file created with the number 12345 in one
cell located in a specific folder. It does not find it.

"Ms-Exl-Learner" wrote:

> Start>>Search>>Select All Files and Folders>>All Part of the File Name:>>Type
> *.xls OR *.xlsx OR *.xlsb OR *.Xlsm>>A word or phrase in the File>>type the
> character or word which is present inside the Excel File>>Lookin>>Select the
> Drive if you know it exactly, Otherwise select My Computer from the Drop Down.
>
> * means that the file may contain any name.
> *.xls OR *.xlsx OR *.xlsb OR *.xlsm will make the search to go through only
> with Excel files other than looking in all files. If you are using Excel 2003
> then use the extension as *.xls in All part of the File Name.
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "deeds" wrote:
>
> > I am trying to do a Windows search to find an Excel file containing a
> > specific number. I have looked everywhere...no luck. I did the File Search
> > option within Excel...no luck. There has to be a way to do this...any ideas?
> > Thanks.
From: Ms-Exl-Learner on 14 May 2010 13:32
Yes some time the search wont work eventhough the File consist the Character
or word in some machines. Try to search it in some other system if the
Folder or File if it is located in server.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"deeds" wrote:

> That does not work. I have a test file created with the number 12345 in one
> cell located in a specific folder. It does not find it.
>
> "Ms-Exl-Learner" wrote:
>
> > Start>>Search>>Select All Files and Folders>>All Part of the File Name:>>Type
> > *.xls OR *.xlsx OR *.xlsb OR *.Xlsm>>A word or phrase in the File>>type the
> > character or word which is present inside the Excel File>>Lookin>>Select the
> > Drive if you know it exactly, Otherwise select My Computer from the Drop Down.
> >
> > * means that the file may contain any name.
> > *.xls OR *.xlsx OR *.xlsb OR *.xlsm will make the search to go through only
> > with Excel files other than looking in all files. If you are using Excel 2003
> > then use the extension as *.xls in All part of the File Name.
> >
> > --------------------
> > (Ms-Exl-Learner)
> > --------------------
> >
> >
> > "deeds" wrote:
> >
> > > I am trying to do a Windows search to find an Excel file containing a
> > > specific number. I have looked everywhere...no luck. I did the File Search
> > > option within Excel...no luck. There has to be a way to do this...any ideas?
> > > Thanks.
 |  Next  |  Last
Pages: 1 2
Prev: how do I save my name as the creater of a workbook
Next: Summing several IF's in a column.