False positive from File | Open "Search" field
False positive from File | Open "Search" field
(OP)
I used the "Search" field in the Excel File/Open dialog to search for workbooks containing the word "curvature". I got some hits and opened them all. I could find the presence of "curvature" in all files except one. I use the workbook search tool (making certain that all sheets are visible) and it cannot find "curvature" in any worksheet. Searched in VBA sheets and there was nothing there either.
What might be driving this false alarm?
What might be driving this false alarm?





RE: False positive from File | Open "Search" field
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: False positive from File | Open "Search" field
RE: False positive from File | Open "Search" field
I've used dnGREP for some searches successfully, but it's got problems with binary files
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: False positive from File | Open "Search" field
See: Opening and searching pdf files from Excel
for examples and some code for searching from Excel.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: False positive from File | Open "Search" field
I've always been concerned about speed issues on the disks, since I have about 3 million files between my two primary disks.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm