W/o program, how to Windows 10 Search Fast (minutes not hours)

sunny123 said:

However, company restrict programming.

There exists a portable version of Everything. Downloads - voidtools

I hope this helps someone and if there is suggestion to improve, that's great!
1. I also found Power BI unlikely as solution. Re: How to Find Excel files for named formulas inc... - Microsoft Power BI Community
2. Powershell (considered more Script than programming) seems best shot. Here is the script to read formulas from Excel File w/o opening Excel, then Name Manager etc.
If there's simpler method, thanks ahead for the info.

Code:

PS T:\> $Excel = New-Object -ComObject Excel.Application
PS T:\> $Workbook = $Excel.Workbooks.Open($filetosearch)
PS T:\> $workbook.Names.Count
416
PS T:\> $workbook.Names[1]
Application            : Microsoft.Office.Interop.Excel.ApplicationClass
Creator                : 1480803660
Parent                 : System.__ComObject
_Default               : =INDEX(COLUMN(),1)
Index                  : 1
Category               : 
CategoryLocal          : 
MacroType              : -4142
Name                   : \c
RefersTo               : =INDEX(COLUMN(),1)
ShortcutKey            : 
Value                  : =INDEX(COLUMN(),1)
Visible                : True
NameLocal              : \c
RefersToLocal          : =INDEX(COLUMN(),1)
RefersToR1C1           : =INDEX(COLUMN(),1)
RefersToR1C1Local      : =INDEX(COLUMN(),1)
RefersToRange          : 
Comment                : 
WorkbookParameter      : False
ValidWorkbookParameter : False

- - - Updated - - -

How to search Excel Files w/o Admin Right when ⒈ Windows 10 Index-Option-Set-NOT-search-File-content ⒉w/o programming ⒊Add-In

I might have found my own answer to question 2 because my AQS has been problematic:
1. kind:spreadsheets is obsolete (I wish there is announcement)
2. kind:document works
However, I still face following hurdle:
1. How to quick view Excel files that match content-criteria. Opening each search result is slow when there are many found. Only
way I know is saving Excel as htm which is quick to open. However:
1. How to search Htm file-content ? File Explorer shows them (by using ext:htm) but not when queried using following
contents: "old_text" ext:htm
2. Unicode is not searchable e.g. contents: "BÓT📧Search﹙OWA_Field_Values﹐﹛Holiday﹜﹐Roster﹚Z⎔📆19369.xlsm[3]". I have been
using Unicode to make formulas ez to view (benefits i/c short length)

Searching programmatically
1. isn't code-intensive
2. much more powerful
1. Unicode capable
2. Combination of Search Criteria is easy
3. Details of result such as
1. Sheet
2. Cell address
4. Results much more user friendly than File Explorer; example
1. Details saved to a file. This become important when I am forced to come back another day when File-Explorer-Search is slow
3. Example: a off-the-shelf function #Find Data in Excel Using PowerShell -- Microsoft Certified Professional Magazine Online
4. Example: following simple PS script (unrefined) finds htm files (which I plan to save Excel so to view w/o opening Excel)

Code:

1.	$List_htm = Get-ChildItem -recurse -Filter *.htm
Pause
# Loop:
foreach ($htm in $List_htm)
{
    # Locate recipient email address to send to:
    # Regex pattern to match:
    # $pattern = '(^\W*.*@.*\.{1,}\w*$)'
    $pattern = 'BÓT'
    $sel = select-string -list $htm -pattern $pattern | Select-Object Line
    If ($Sel -eq $null)
{
    write-host "FAILS - $htm does NOT contain $pattern"
}
Else 
{
    write-host "WORKS! $pattern `n$sel"
} 
Write-host "end"
    $EmailAddressee = $PDFFolder + "EmailAddressee.txt"
    $sel | Out-File $EmailAddressee
}

One faster File Search method ( 2 minutes vs. an hour plus for Windows 10 File Explorer) is Powershell console using following

Code:

FORFILES /P t:\ /S /M "BÓT*.*" /C "cmd /c echo @Path"^

Problem is Powershell Console will search Unicode but only show some Unicode characters. (as detail in)
How to show Unicode in Windows 10 PowerShell Console same as FE