There is no attachment that I can find however: First you must declare the ext data sheet by using something like db = OpenRecordSet("Name of data sheet"), and use Var = RecordSetRowCount(db) to get the number of rows from the sheet. Then you can start a for loop using For x = 1 to Var
I usually declare the title of each column something like ColName(1)="name of col", ColName(2)="next name of column" and so forth.
Then in the body of the script, within the for loop, all you need to do is retrieve the data by row from each column like: Col = ColName(x)
Data = GetRowValue(db,Col) then use the data as you need to.
I hope this helps you.
Success is the ability to go from one failure to another with no loss of enthusiasm.
~ Winston Churchill ~