07-19-2010, 12:54 PM
get values from data table and make them into a single string.
Ex:
Ex:
Code:
DataTable.SetCurrentRow(i)
a = DataTable.Value("Col ID","Sheet ID")
DataTable.SetCurrentRow(j)
b = DataTable.Value("Col ID","Sheet ID")
t = a&","&b 'If a and b both are string
If not,
t = CStr(a)&","&Cstr(b)