Newbie Question about Send command

[GianniD]

Hey everyone. I am trying to write a command to enter a formula into excel and have it contain a variable within it. Now since i'm new to AutoIt i may be doing this a very drawn out way but nonetheless it sort of works.

This is my code:

$var1=9

Sleep(5000)

While $var1 < 10

Send("{ENTER}")

Send("{F2}")

Send("=6371.1*((2*ASIN(SQRT((SIN((RADIANS(Data!C"$var1")-RADIANS(Data!F2))/2)^2)+COS(RADIANS(Data!C"$var1"))*COS(RADIANS(Data!F2))*(SIN((RADIANS(Data!B"$var1")-RADIANS(Data!G2))/2)^2)))))*1000)")

$var1=$var1+1

WEnd

The part where $var1 is is where i want to enter the variable but i keep getting an error. Could someone help me with the syntax?

Thanks

[omikron48]

It should be:

Send("=6371.1*((2*ASIN(SQRT((SIN((RADIANS(Data!C" & $var1 & ")-RADIANS(Data!F2))/2)^2)+COS(RADIANS(Data!C" & $var1 & "))*COS(RADIANS(Data!F2))*(SIN((RADIANS(Data!B" & $var1 & ")-RADIANS(Data!G2))/2)^2)))))*1000)")

If you need those double quotes to be part of the formula, it would be:

Send('=6371.1*((2*ASIN(SQRT((SIN((RADIANS(Data!C"' & $var1 & '")-RADIANS(Data!F2))/2)^2)+COS(RADIANS(Data!C"' & $var1 & '"))*COS(RADIANS(Data!F2))*(SIN((RADIANS(Data!B"' & $var1 & '")-RADIANS(Data!G2))/2)^2)))))*1000)')

Edited October 26, 2009 by omikron48

[enaiman]

You keep forgetting the & - that's why you get the error.

Send("=6371.1*((2*ASIN(SQRT((SIN((RADIANS(Data!C"&$var1&")-RADIANS(Data!F2))/2)^2)+COS(RADIANS(Data!C"