I am reading a large number of rows by a large number of columns by column from a spreadsheet. I've found the easiest way is to use NextRow(db) then reset the rows to the top. I just haven't found an easy method for resetting the row counter to the top. Currently I re-declare the db variable like: <db = OpenRecordSet("Standard Main")>, but since I need to change the sheet name so that I can reuse the script, I need to be able to reset based on a passed varible, if possible. I've tried a loop using "PrevRow", but that gets slow and messy.
Any ideas on resetting the row counter?
Success is the ability to go from one failure to another with no loss of enthusiasm.
~ Winston Churchill ~