Category: Excel

Googling for "Microsoft Windows 10 Cortana®" reveals MANY complaints about memory loss - even when Cortana's voice listening and response services are DISABLED / "inactive"! The best advice found on the forums to-date has been "remove" or "rename it"!

Usually a BAD workaround! Especially since it is and error prone IMPOSSIBLE to do it manually.
Therefore this BATCH file is offered with the warning "EXAMPLE only! Do *NOT* attempt this on any computer. This batch file is ONLY OFFERED as an example of the "IF" statement and batch logic flow."

@echo off

rem set statusstring="end of %0"SET /P ISADMIN=Are you RUNNING THIS AS ADMIN (usually from a shortcut 'RUN AS ADMIN') Y/N: =if /I NOT "%ISADMIN%"=="Y" goto OOPSrem KLUDGE to SOLVE MEMORY HOG PROBLEM
rem CORTANA is MICROSOFT's AUDIO LISTENER
rem it can take 20-30% or more of RAM
rem can't MANUALLY RENAME or MOVE it because Task Manager RELOADS it
rem SOLUTION: replace MANUAL steps with BATCH commandssetlocalrem @echo onecho step 1 kill SearchUI and renameIF%ERRORLEVEL% GTR 1 SET ERRSTRING=errlevel%ERRORLEVEL%

This is a sample of "stub" code using REGEX (regular expressions) to find predefined Error words

detect and skip Windows Certificate Errors or similar Error page that IE may surprise the user with

Fill in a Login Form

To WORK: it needs you to identify the (login or other) form elements

identify a unique STRING in the unexpected Error (Certificate) page

'________________________Function checkForError(strErr,strTag)' returns 1 of 3 strings FULL LARGE INNERTEXT STRING IF ERR FOUND, ELSE "PASS"Dim names,ele,innerText,outerText,temp,bFlag' used as string to debugtemp=""bFlag=False' flag True if ERR FOUND, false if ERR NOT FOUNDSet names=objIE.Document.getElementsByTagName(strTag)

' sample: needs IE page object to be defined and navigated to as current page, having login form elements'√' CHECKING for and bypassing MICROSOFT CERTIFICATE WARNING

isUnsafe=findClickOkIfUnsafe("not recommended",testLinks)'bad string is first param signalling certificate errorIf isUnsafe>=0then testLinks(isUnsafe-1).Click'(1) works if HARD CODED FROM OBSERVATION - code returns (2) ??
' testLinks(isUnsafe).Click ' using index as boolean???? xyzcall waitForReady(objIE)' do this after each click on menuend If ' self documenting comments by doing "find" of H4 tag or any desired flag/tag