ClipPut issues

[Newbie2]

Hi guys,

I must be doing something very wrong. Im trying to scan an excell file (which is open). What's wrong in this?

Send ("^c")
$x=clipget ()
msgbox (0,"",$x); It displayes 5
If $x = "5" Then
msgbox (0,"","OK"); Never arrived here! WHYYYYY?
EndIf

Edited September 7, 2004 by Newbie2

[Jos]

Hi guys,

I must be doing something very wrong. Im trying to scan an excell file (which is open). What's wrong in this?

Send ("^c")
$x=clipget ()
msgbox (0,"",$x); It displayes 5
If $x = "5" Then
msgbox (0,"","OK"); Never arrived here! WHYYYYY?
EndIf

<{POST_SNAPBACK}>

Didn't test it but could it be that the $x var contains leading or trailing spaces ??

Try $x=StringStripWS(clipget (),3) and see if that works...

[Newbie2]

Bingo!!

I wonder why a simple excel cell contains leading or trailing spaces...

[Somerset]

hey the code works just fine... did you remmber that you have to highlight the stuff before it can be put on the clipboard?

[Newbie2]

Yes, Beerman,

I have highlighted it before running the script. However, w/o Jdeb's fix, it doesn't work...

[Somerset]

well what i think you are doing is this

highlighting text executing script and not putting a delay on the script or calling attention back to the window.... you have to do that, before it knows what to copy....do this. put a sleep delay on your script, like 30 seconds or something. highlight what you want then wait.... see if that works... you have to remmber to draw windows attention back to the window you want the text copied from.

[Newbie2]

Delay is not the problem.

I have put the delay needed, but it's not submitted in the piece of script I have submitted.

The probelm is that excel adds some spaces so If $x = "5" Then... will never be true unless you strip out the spaces by using Jdeb's fix.