B
Bill
I had a couple Applescripts that failed after my upgrade to Office v.
2004. While some things were easily fixed, I can't get around the
fact that Getting column info returns the column index, yet to get the
value of a cell you can't address it with R(x)C(y) where x and y are
indexes.
Example:
set the_first_row to the first row index of selection
set the_first_col to the first column index of selection
set the_count_of_rows to the count of rows of selection
set the_count_of_cols to the count of columns of selection
get value of cell ("R" & the_first_row & "C" & the_first_col) to
this_old_filename
The last statement fails. In other scripts the column is pre-defined,
so I could use:
get value of cell ("B" & the_first_row) to this_old_filename -- column
B is pre-defined
Does anyone know how to get the value of a cell, referring to it with
column and row indexes in Excel 2004? (i.e cell R50C4 instead of D50)
2004. While some things were easily fixed, I can't get around the
fact that Getting column info returns the column index, yet to get the
value of a cell you can't address it with R(x)C(y) where x and y are
indexes.
Example:
set the_first_row to the first row index of selection
set the_first_col to the first column index of selection
set the_count_of_rows to the count of rows of selection
set the_count_of_cols to the count of columns of selection
get value of cell ("R" & the_first_row & "C" & the_first_col) to
this_old_filename
The last statement fails. In other scripts the column is pre-defined,
so I could use:
get value of cell ("B" & the_first_row) to this_old_filename -- column
B is pre-defined
Does anyone know how to get the value of a cell, referring to it with
column and row indexes in Excel 2004? (i.e cell R50C4 instead of D50)