MarkV,
Thanks so much for your help.
I suppose the response to my question could have been RTFM properly! I would say in my defense, I was not aware of the 'Excel Bound Variables' and my reference to the manual, revealed on page 102, {sheet_name}!{cell_address}...
Now that I am able to GET values from cells within the excl sheet, I am now trying, unsuccessfully, to SET values in cells in excel.
I will ask the question here, but if it is not the place to ask, I will ask a fresh question in another post...
given that I can get values using cell_sheet_cellReference, I assume I cannot write values to excel using that syntax?
I have a plan to write the selections' values, at settle time, on the horses. I want to write ["market_name"] in column A, ["sel_name"] in column B, and [sel_place] in column C. I am referring to COLUMN, rather than A1, B1, C1, because I want to write a value for each selection, in its own row, for each market that is used.
I decided to have a formula in excel to give the row number of the next empty cell, and I used =SUMPRODUCT(MAX(($A:$A<>"")*(ROW(A:A)))) + 1
I have this formula on cell J1
The formula shown will give the last filled cell in column A, and I put in +1, to give me the next row, which has an empty cell, in column A...
So, with that, in order to write these 3 entries into the excel sheet, I wanted to use a triple set of write to Excel actions as :
write ["sel_name"] Cell address shtSheet!B(cell_shtSheet_J1)
write [sel_place] Cell address shtSheet!C(cell_shtSheet_J1)
write ["market_name"] Cell address shtSheet!A(cell_shtSheet_J1)
so, if the last empty cell in column A is A5, then the first action above will write the selections name into B5, it win status (win or lose, 0 or 1), into C5, and finally the market name into A5..
Once these 3 values have been added, the formula shown above will detect an entry into A5, and the value in J will now be 6...
Seems logical enough, but I am not sure this will work...
Why?
Well, in order to test the theory of referencing the value in J1, I did a straight user variable check, as cell_shtSheet1_J1, and it gave me the value 5, no problem
BUT
by manually adding a value into cell B5, such as 'hello' - When I did cell_shtSheet_B(cell_shtSheet_J1), the value shown was the literal, as cell_shtSheet_B5
So, to check this I put another variable in there, as cell_shtSheet_B5, and the value shown was 'hello'
So, using a direct reference to cell_shtSheet_B5, I am able to see the value held in that sell, but using a construct as cell_shtSheet_B(cell_shtSheet_J1), Iam not able to see the value...
Did I do something wrong here?
Can my triple set of write action's work? Is there a different way I need to do it?
Thanks
Mark.