A user asked me a question to get past a recurring popups . It seems like this is a 1 time job – so cheezy solutions are acceptable (right!?)

Write a quick script to click the annoying popup for you. I did for another example and the code is below on how I did it. My example checks for 2 things a) do I see the popup and b) is Excel running – but the concept applies (and it works.) Download AutoHotKey – corps block this – so … do it at home and bring it in … then make the script and generate a .exe and run it in the background while you are doing your task.

Here is my script that worked for me …

[c]

 

Sleep, 50

SetKeyDelay,500

Loop 480
{

If WinExist("Heidi Module Load Error") {

WinActivate
SetControlDelay -1

; MsgBox, 0, ,The heidi window exists
ControlClick, Button1,,,,, NA
; Send {Space}
Sleep,100

}

Sleep 1000

If WinExist("Microsoft Excel") {

WinActivate
SetControlDelay -1

ControlGetText, OutputVar, MSOUNISTAT1
If (OutputVar = "Microsoft Excel is waiting for another application to complete an OLE action.") {
; MsgBox, 0, ,So does the excel popup
} else {
; MsgBox, 0, ,NO EXCEL WINDOW DETECTED
}
ControlClick, Button1,,,,, NA
; Send {Space}
Sleep,100
; MsgBox, 0, ,So does the excel popup
}
Sleep, 29000
}

 

return

[/c]