if condition

[EasyGoing]

I am trying to copy a cell in excel and then valuate it.

here is my code that doe snot work. I get a error

WinActivate("Microsoft Excel - question.xls")

WinWaitActive("Microsoft Excel - question.xls")

Send("^c")

Sleep(100)

$occupation = ClipGet()

If

if $occupation = "Tenet" Then

Send("{ENTER}")

Sleep(100)

SEND("^V")

Else

Send("{ENTER}")

Sleep(100)

SEND("Did not work")

EndIf

[Zedna]

remove one "if":

WinActivate("Microsoft Excel - question.xls")
WinWaitActive("Microsoft Excel - question.xls")
Send("^c")
Sleep(100)

$occupation = ClipGet()

If $occupation = "Tenet" Then
    Send("{ENTER}")
    Sleep(100)
    Send("^V")
Else
    Send("{ENTER}")
    Sleep(100)
    Send("Did not work")
EndIf

[EasyGoing]

Thank you, but it still does not work.

I copied and pasted your codes and it jumps to the else statement " It does not work". I does not even do the other send commands.

[evilertoaster]

well you could error check to be sure you condition fires (check that value of the varible)

Humm but really if you doing some work with excel http://www.autoitscript.com/forum/index.php?showtopic=34302

would proably work nicely...