row didn't exist... should have noticed that myself


thanks for the help!

Starting up a big project. My goal is to open multiple excel files, look for lines that are "past due" and enter the values as a summary into another excel sheet or word document. I want to have a master file of the names of the excel sheets. The script will use this master sheet and open up the oth...

If anyone runs into something similar to this, here was my solution.
Added:

Let>stop=0
Repeat>row

if>field_2<>field_22
let>stop=row
end if

Until>row=stop


Special shout out to Grovkillen for being so helpful!

I'm not getting an error message but it isn't repeating Here is my entire test: Let>filename=C:\Users\USER\Desktop\ExcelTest.xlsx XLOpen>filename,1,xlH setfocus>ExcelTest let>row=1 let>check=2 repeat Let>row=row+1 Let>check=check+1 XLGetCell>xlH,Sheet1,row,2,field_2 XLGetCell>xlH,Sheet1,check,2,fiel...

I'm having issues figuring out the correct syntax I am looking to repeat a function until the row after the row I am working on is a different value. These values are coming from excel Value 1: XLGetCell>xlH,Sheet1,row,2,field_2 Value 2: XLGetCell>xlH,Sheet1,check,2,field_22 I am having issues with ...