Customer Center

Thanks Thom,

That is a useful tip. Does the note in the help file apply with this approach?

“However if you set the Record property to a value that is lower than the current Record, the file is closed, re-opened, and then scanned to the requested record number.”

My script is reading from Excel file and first needs to key the value located in G3 into my Rumba application. So I used D.Next to get to record three. Now I need it to go back to the second record to continue keying the rest of data which sits in columns A-F.

I was concerned that using D.Record will hinder script performance if it has to close and reopen the file.