04-18-2006, 06:41 PM
Thanks Gintaras,
The second version is a LOT faster than the first! I tried to enhance this version to grab columns 'A', 'B', 'C' to fill in multiple fields. The code I tried (which does not work) was:
act "Notepad"
spe 0 ;;maximum speed
ARRAY(str) row
int column='A' ;;change this if you need other column
int column2='B'
int column3='C'
foreach row "" FE_ExcelRow
,key "*"; key T
,row[column-'A'].setsel
,key T; key T
,row[column2-'B'].setsel
,key T
,row[column3-'C'].setsel
,key Y
I think I am getting closer. Unfortunately, the value in column 'A' gets placed in all three fields in notepad rather than the unique data from columns 'A', 'B', 'C'.
Thanks again for the help.
The second version is a LOT faster than the first! I tried to enhance this version to grab columns 'A', 'B', 'C' to fill in multiple fields. The code I tried (which does not work) was:
act "Notepad"
spe 0 ;;maximum speed
ARRAY(str) row
int column='A' ;;change this if you need other column
int column2='B'
int column3='C'
foreach row "" FE_ExcelRow
,key "*"; key T
,row[column-'A'].setsel
,key T; key T
,row[column2-'B'].setsel
,key T
,row[column3-'C'].setsel
,key Y
I think I am getting closer. Unfortunately, the value in column 'A' gets placed in all three fields in notepad rather than the unique data from columns 'A', 'B', 'C'.
Thanks again for the help.