its so incredibly easy to make an Excel file, and it will accept the variables that come right out of the database
but I found out the indexing for the Sort() was 0th based not 1-based, so doing ws.Sort(5) had it sort on column F not column E; and col. F was just Y or N, so looking at the dates being out of order it seemed not to sort, plus its got colored rows that are mixed.
But it has another problem where it sorts good now using ws.Sort(4) gets sorting on col “E”
then it goes back and sorts col. 1 on those values splitting up the row data, which to me seems like its never supposed to do because now the row data is corrupt.
.
