If then and variables

[stolie]

Hi me again,

Ive tried everything and im going nuts.

This is a sample of what im doing, basically, i want a message box to appear when the text in the clip board says a word, in this example, "end"

$y = Clipget()

Winactivate ("Microsoft Excel")

Send ("^c")

If $y= "end" Then

MsgBox(0, "finished", "Stop the Macro,")

Endif

What am i doing wrong? Its not recognising what is in the clipboard memory?or has it something to do with excel?

Thanks in advnace

[DaleHohm]

Hi me again,

Ive tried everything and im going nuts.

This is a sample of what im doing, basically, i want a message box to appear when the text in the clip board says a word, in this example, "end"

$y = Clipget()

      Winactivate ("Microsoft Excel")

       Send ("^c")

           If $y= "end" Then

                MsgBox(0, "finished", "Stop the Macro,")

           Endif

What am i doing wrong? Its not recognising what is in the clipboard memory?or has it something to do with excel?

Thanks in advnace

<{POST_SNAPBACK}>

Your initial $y = Clipget() does not set up a permanent linkage with the clipboard... it takes a snapshot. Each time you want to evaluate the contents of the Clipboard (i.e. after the content changes) you must do another Clipget().

Dale

Edited August 9, 2005 by DaleHohm

[stolie]

Dale, thanks for your reply.

Even when i run the above with just one cycle, ie, it only has ever had one item in the memory it doesnt work, it seems to not recognise what has been copied from excel.

[LxP]

Excel is possibly copying extra data before or after the keyword or it is copying in a non-plain-text format.

Try checking for the keyword's presence using If StringInStr(ClipGet(), "end").