Execute a command upon certain text appears inside a running window

[laurence77at]

Dear all,

I am new to the forum.  Can anyone show me how to run a command upon some text shows up in the status bar of a window?

e.g. close the window/program when the status bar shows the word "finished".

I tried:

If Winexists ("[Finished]") Then Winclose ("Program - ", "")

but then some error pops up like: if winexists (      - ^ error   subscript used on non-accessible variable

Perhaps my syntax is wrong?

Thank you!

Laurence

[ad777]

@laurence77at

can you show image of  window your using.

just use StatusbarGetText:exsample below:

#include <MsgBoxConstants.au3>
Local $Part = 1;The "part" number of the status bar to read - the default is 1. 1 is the first possible part and usually the one that contains the useful messages like "Ready" "Loading...", etc.
Local $sText = StatusbarGetText("title of window here",'',$Part)
MsgBox($MB_SYSTEMMODAL, "", "status bar says: " & $sText)

& e.g. close the window/program when the status bar shows the word "finished":

#include <MsgBoxConstants.au3>
Local $Part = 1;The "part" number of the status bar to read - the default is 1. 1 is the first possible part and usually the one that contains the useful messages like "Ready" "Loading...", etc.
While 1
Local $sText = StatusbarGetText("title of window here",'',$Part)
if  $sText = "Finished" Then
WinClose("Program - ","")
ExitLoop
Endif
Sleep(50)
Wend

 

Edited February 27, 2022 by ad777

[laurence77at]

Thanks ad777,

Excellent. I guess the above loop will keep monitoring the status bar till the desired text appears?

How about if the full text just contains the words "Finished"?
(the status bar not exactly shows "Finished", but maybe something like "Finished at here or there", or only contains the words "Finished")

if $sText =

Thanks!

[Nine]

StringInStr (see help file)

[ad777]

2 hours ago, laurence77at said:

How about if the full text just contains the words "Finished"?
(the status bar not exactly shows "Finished", but maybe something like "Finished at here or there", or only contains the words "Finished")

if $sText =

Thanks!

Add StringInStr As @Nine Say's :See script below:

#include <MsgBoxConstants.au3>
Local $Part = 1;The "part" number of the status bar to read - the default is 1. 1 is the first possible part and usually the one that contains the useful messages like "Ready" "Loading...", etc.
While 1
Local $sText = StatusbarGetText("title of window here",'',$Part)
Local $word = "Finished"
if StringInStr($sText,$word) Then
WinClose("Program - ","")
ExitLoop
Endif
Sleep(50)
Wend

 

[laurence77at]

It works.  Many thanks to ad777 and Nine.

[laurence77at]

Further to the above question, I want to further relax the criteria so that when the text appears in any part of the window, it works.

I have tried to use Wingettext , but an error pops up:

 

Local $Part = 1;The "part" number of the status bar to read - the default is 1. 1 is the first possible part and usually the one that contains the useful messages like "Ready" "Loading...", etc.
While 1
Local $sText = WinGetText("Program",'',$Part)
; the below $word = and $sText = will make all text containing "finished" to function!
Local $word = "Finished"
if StringInStr($sText,$word) Then
WinKill ("Program")
ExitLoop
EndIf
Sleep(50)
Wend

 

Any idea?

Thanks.

 

 

 

 

 

 

 

 

[ad777]

@laurence77at

Next Time you should read help file.

Url for WinGetText:https://www.autoitscript.com/autoit3/docs/functions/WinGetText.htm

While 1
    Local $sText = WinGetText("Program", '')
    ; the below $word = and $sText = will make all text containing "finished" to function!
    Local $word = "Finished"
    If StringInStr($sText, $word) Then
        WinKill("Program")
        ExitLoop
    EndIf
    Sleep(50)
WEnd

 

[laurence77at]

Thanks.  

I am using the below call for opening an excel workbook,

 

#include<excel.au3>
Local $Var = "D:\workbook.xls"

Local $oExcel_1 = _Excel_Open()
_Excel_BookOpen($oExcel_1, $var)

 

the book opened, but returned an autoit error:

 

Line 227 (File "C:\Program Files\Autoit3\Include\Excel.au3

$oExcel.windows($oWorkbook.Name).Visible = $bVisible
$oExcel.windows($oWorkbook.Name)^Error

Error: Variable must be of type "Object",

 

Any idea??

 

[Nine]

Please use tags when you post code, as described in the previous link

Your code is missing the assignment of $oWorkbook.  Provide a runable code if you want us to test it...

[laurence77at]

Hi Nine,

The code is there, it is just that simple - to open a excel workbook with a path and filename!

I searched over and over the forum and help but still don't know why the error pops up, however, the file opened.

I even tried the 'on error go to' you made earlier but to no avail....

Please help.

#include<excel.au3>
Local $Var = "D:\workbook.xls"

Local $oExcel_1 = _Excel_Open()
_Excel_BookOpen($oExcel_1, $var)

 

 

 

 

 

 

Edited March 3, 2022 by laurence77at

[junkew]

$oworkbook is not assigned a value as said before.

Best advice is study examples in helpfile for functions you are using.

 

Edited March 5, 2022 by junkew

[caramen]

  

This is a solution I get from this post :

And I had this script from the topic : (Whitch helped me a lot in lot of similar situation.)

It could react the same with your shell console. You have to redefine the code as you need.

expandcollapse popup

#include <constants.au3>
#include <string.au3>
#RequireAdmin

; Use RunAs if you want use a fixed username/password within the script:
; Global $hPowerShellPID = RunAs("UserName", "Domain", "Password", "", "powershell.exe", '', @SW_HIDE, BitOR($STDIN_CHILD, $STDERR_MERGED))

; or use #RequireAdmin and a simple Run Statement to enter Admin credentials (if needed) at runtime
; Here we start a "permanent" powershell prompt with redirected streams
Global $hPowerShellPID = Run("powershell.exe", '', @SW_HIDE, BitOR($STDIN_CHILD, $STDERR_MERGED))

; this little loop is to wait for the "welcome" message from powershell
; just a way to be sure that the powershell is running and "streaming"
Do
    StdoutRead($hPowerShellPID)
Until @extended ; out stream started

; example:
; Here we "execute a command via the Powershell that is running in background...
; ...and we get back to resulting output
Local $Out = _Run_Cmdlet("Get-ItemPropertyValue 'Registry::HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System' -Name 'EnableLUA'", $hPowerShellPID)
ConsoleWrite($Out)

; here another command
ConsoleWrite(_Run_Cmdlet("dir c:\", $hPowerShellPID))

; .... and so on ...

; this function execute the passed powershell command and returns the resulting output
Func _Run_Cmdlet($sCmd, ByRef $hPS)
    Local $sStdOut = ''
    ; we insert a start and an end message in order to identify the "body" of the result of the command executed
    $sCmd = 'write-host "->StartOfStream<-"; ' & $sCmd & '; write-host "->EndOfStream<-"' & @CRLF
    StdinWrite($hPS, $sCmd)
    Do
        Sleep(250)
        $sStdOut &= StdoutRead($hPS)
        ; the presence of the known end message signals the end of the execution
    Until StringInStr($sStdOut, "->EndOfStream<-" & @LF)
    ; return only the body of the outpu of the passed command
    Return _StringBetween($sStdOut, "->StartOfStream<-" & @LF, "->EndOfStream<-" & @LF)[0]
EndFunc   ;==>_Run_Cmdlet

I'm sure you could done your goal with this

 

Enjoy.

Thanks @Gianni btw.

[laurence77at]

Thank you Junkew and Caramen, I finally found the below post that solved the "bug":

Simply by changing the Excel.au3 with the updated code avoided the error.

Should this be included in the include folder in future autoit releases?

Thanks.

[junkew]

I am not sure what you did but this should have been enough

 

$oWorkbook=_Excel_BookOpen($oExcel_1, $var)