VBA coding help (Table ordering)

[latecnik]

Hi There,

I have an Excel 2007 table already ordered by one key (one of the table´s fields).

I need to get in VBA the current order (Ascending or Descending) of the table.

I've tried somethis like this:

MsgBox ActiveWorkbook.Worksheets("MySheet").ListObjects("MyTable").Sort.SortField.Key

But I get runtime error 438 regarding the object not admitting this method or property.

I guess it have to be some problem with my coding, but can't find it yet...
Any ideas?

Thank you very much in advance!

JoseLuis

 

[latecnik]

This one does the trick:

MsgBox ActiveWorkbook.Worksheets("Diario").ListObjects("tDIARIO").Sort.SortFields(1).Order