06-09-2007, 06:03 PM
Hi there,
I used some code what i found on this forum, i adapted it a little bit but i cannot get results:
str s=found
out s
mes s
ARRAY(str) h
ExcelSheet es1.Init
int sheet1 row col found
for(sheet1 1 sheet1+1)
es1.Init(sheet)
es1.GetCells(h)
for row 0 h.len(2)
for col 0 h.len(1)
if(h[col row]=s) found=1; goto g1
g1
if(!found) mes "not found"; ret
mes "sheet %i, row %i, column %c" "" "i" sheet1 row+2 'A'+col
Everytime i get a 'not found message' but the thing i'm searching for is definately in the sheet.
When i create a new macro and run it from there and change s="hello" it works perfectly
Does somebody see a mistake or something?
The str s=afound should populate s with the earlier found results it is an ARRAY(str) something with this maybe?
Plz help me
I used some code what i found on this forum, i adapted it a little bit but i cannot get results:
str s=found
out s
mes s
ARRAY(str) h
ExcelSheet es1.Init
int sheet1 row col found
for(sheet1 1 sheet1+1)
es1.Init(sheet)
es1.GetCells(h)
for row 0 h.len(2)
for col 0 h.len(1)
if(h[col row]=s) found=1; goto g1
g1
if(!found) mes "not found"; ret
mes "sheet %i, row %i, column %c" "" "i" sheet1 row+2 'A'+col
Everytime i get a 'not found message' but the thing i'm searching for is definately in the sheet.
When i create a new macro and run it from there and change s="hello" it works perfectly
Does somebody see a mistake or something?
The str s=afound should populate s with the earlier found results it is an ARRAY(str) something with this maybe?
Plz help me