Question about the use of Clipboard function

[Akshay07]

Hello all,

I have a question about the use of the Clipboard function.

I see a problem in my script, but it is very random and very difficult to reproduce, therefore I would like some help on the code (but I am unable to retest it in a few minutes, it will take many attempts). if you see any mistake in the code, could you please let me know?

Here is what the script does:

1/ Take a screen capture of a window and paste it into an excel spreadsheet:

$hBitmap = _ScreenCapture_CaptureWnd("", $hWnd)
_ClipBoard_Open($hWnd)
_ClipBoard_Empty()
_ClipBoard_SetDataEx($hBitmap, $CF_BITMAP)
_ClipBoard_Close()
$oExcel.Application.ActiveSheet.Range($sSTCell).Select
$oExcel.Application.ActiveSheet.Paste
_WinAPI_DeleteObject($hBitmap)

2/ Copy/paste some text from another document into the excel spreadsheet using "CTRL+c" and "CTRL+v" (this is achieved using the Send function)

This works almost all the times, but some times, when I send "CTRL+v", the screen capture is pasted again instead of the text selected in 2/

I was thinking of changing 1/ into this:

$hBitmap = _ScreenCapture_CaptureWnd("", $hWnd)
    _ClipBoard_Open($hWnd)
    _ClipBoard_Empty()
    _ClipBoard_SetDataEx($hBitmap, $CF_BITMAP)
    $oExcel.Application.ActiveSheet.Range($sSTCell).Select
    $oExcel.Application.ActiveSheet.Paste                                              ; Paste image
    _ClipBoard_Empty()
    _ClipBoard_Close()
    _WinAPI_DeleteObject($hBitmap)

Could this help?

Thanks!

A.

Edited February 1, 2010 by Akshay07

[james3mg]

Maybe. But it's more likely that the result of clearing the clipboard will result in nothing being available to paste in step 2. My guess is that it's the Ctrl+C that's getting dropped...maybe your script isn't waiting for the "other" window to become fully active before copying?

I'd consider checking the contents of the clipboard after you send the Ctrl+C...if it's a bitmap, re-activate the "other" window, wait 100ms or so and re-send a Ctrl+C. Maybe loop that over and over until the contents of the clipboard are a text string before continuing on with the Ctrl+V part of your script.

[Akshay07]

Maybe. But it's more likely that the result of clearing the clipboard will result in nothing being available to paste in step 2.

Thanks for your answer. But at this stage, I still did not copy anything related to step 2.

I just don't understand why it works only 99% of the time

I'd consider checking the contents of the clipboard after you send the Ctrl+C...if it's a bitmap, re-activate the "other" window, wait 100ms or so and re-send a Ctrl+C. Maybe loop that over and over until the contents of the clipboard are a text string before continuing on with the Ctrl+V part of your script.

Sounds good! I'll try that.

Edited February 2, 2010 by Akshay07