Gudday Joe,

Ok it would appear that you have sorted getting an excel object through vb. To sort on a field, don't have vb in front of me to look up the code , open the excel spreadsheet and start a marco recording, do your normal actions to sort by column, then stop the macro recording, (will ask for a name). Then simply look through the vba code produced. VB will be able to replicate this through the excel object properties, just code it in a routine.

This is how l am learning to manipulate excel. If any problems email me at [email protected] and l will do it on one of the office machines and send ya the code.