Varaibles on Variables with Excel

[Novalak]

Im having troubles calling a variable within a variable
for instance, i look through some code with excel - once it hits a row which meets, i grab the line

For example

Input>Sheet,Sheet?,Sheet1
Let>Excel=C:\Upload\Test.xls
XLSheetToArray>%Excel%,%Sheet1%,xlData
<LOOP CODE>
Let>URL=xlData_%count%_3
SMTPSendMail><email>,<server>,<from>,<name>,<Subject>,%URL%,

So basically lets say row 100 meets the condition, the URL variable should get populated with the contents of xlData_100_3
Instead, URL becomes xlData_100_3 which then my mail makes no sense


What am i missing here?

[Marcus Tettmar]

What do you see in the watch list after the XLSheetToArray call. You should see the xlData array variable in the watch list. If you double click that you'll see the values. Is xlData_100_3 showing there?

[Novalak]

Its working

it doesnt work when i put this in the data
SMTPSendMail><email>,<server>,<from>,<name>,<Subject>,xlData_%count%_3,

but works if i name the variable first

Let>URL=xlData_%count%_3
SMTPSendMail><email>,<server>,<from>,<name>,<Subject>,%URL%,

[Marcus Tettmar]

Yes, that's expected.