Lo all, only just found this site using altavista.

Basically i am writing a program which will show football league tables using text boxes, and an OLE from Excel which has the basic details of the teams points etc.

I have been able to do that fine however I can't seem to be able to think of the code or find the code which will be able to sort the records within the objExcel.

So what I am trying to get to happen is that when you click on a command (in this case cmdShowNew) it will sort the records within my excel OLE and put them in alphabetical order. The field which I want to sort is the first field and starts from record 2 i.e the field has a title in this case TEAMS, and i want to sort the records which start in A2 to A7 (I've got 6 teams within my league)

If any1 could help that would be extremely grateful.