Problems with target window losing focus

[Gabby]

I'm running a function that halts as soon as the target window loses focus. I have similar functions that don't use the clipboard which work OK, ie they continue when the window loses focus.

Any suggestions?

Code: Select all

;*** This function is used for replacing WAP [Blank] cells with nulls (by deleting them).
; It processes up to 3000 cells, tabbing to the next. If it finds "X!x" in a cell it
; it then stops. Note that when the [Blank] cells are copied, they return a null string,
; so there's no difference between them and otherwise blank cells.
Do_Deblank:
  loop 3000
    {
    Cclip := Copy_clip()                ; do a ^C and get clipboard text.
    if (Cclip = "X!x")                    ; Termination delimeter
      {
      send {Del}
      EXIT
      }
    if Cclip =
      {
      send {Del}
      }
   send {Tab}
    }
  EXIT

[divanebaba]

Code: Select all

SetTitleMatchMode, 1 ; must start with ...
Do_Deblank:
 loop 3000
    {
    if !WinActive("Microsoft - Excel")
    break
    Cclip := Copy_clip()  
    ....

So if your focused window is not active, the loop stops now. You just have to find the title of your window and to change choosen example in code above.

[Gabby]

Okayyy. So that will let me stop the loop when the window loses the focus. I suspected that the problem was using Copy on an inactive window.

Trouble is, the window contains a grid and I've only found one way to get the cell data, which is by using Copy. GetControlText isn't returning the cell contents. So is there any way to send Copy to a window that isn't active?

I should have added my Copy_clip sub which is:

Code: Select all

Copy_clip() {           ; ===================
  clipboard =           	;empty clipboard
  Send ^C               		;copy to clipboard
  clipwait              			;wait till something in clipboard, even blank.
  CB := clipboard
  return CB
  }

[divanebaba]

Hi.
Are you using Excel? If yes, there are most reliable solutions with COM.
Btw: When you use clipwait inserting a little sleep is sometimes needed for stable function. Look here:

Code: Select all

Copy_clip() {           ; ===================
  clipboard =           	;empty clipboard
  Send ^c               		;copy to clipboard
  sleep 50		; makes clipwait more reliable
  clipwait              			;wait till something in clipboard, even blank.
  CB := clipboard
  return CB
  }

[Gabby]

Thanks for that. No, not Excel - it's an app without any form of API (Excel would be easy).