How to search closed workbook for number?

  • Thread starter Thread starter Sean Flanagan
  • Start date Start date
S

Sean Flanagan

Hi; please help me discover how to search closed Excel
2000 workbooks for numbers. I have numerous workbooks
with only one worksheet, containing rows with a six-digit
number in some colum. Perhaps the number is stored in
Excel's own representation, because using Windows 'Search'
does not find a workbook with a known numeric value.

Any suggestions will be deeply appreciated.

Thanks,
-Sean-
 
You can use Vlookup

=VLOOKUP(A1,'C:\yours\[yours.xls]worksheetname'!$A$1:$A$100,1,FALSE

Or use a VBA macro to loop through the workbooks
 
I would open them one at a time, do the search, and then close it.

You can keep it all hidden from the user.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top