Excel Table Objects, How to refer to?

[Roopher]

Hello all!

I have worksheets with five Excel Table Objects in it. They had been formed by Excel after an XML import. These objects had been given names by Excel. I can see and rename them in Excel's UI via Formla->Names Manager (Ctrl-F3).

I'd like to use these objects from VBA, but cannot get hold of them. They have names, e.g. "Table04" in the Excel UI, but when I run a "MsgBox ThisWorkbook.Names.Count" statement, I always get "0" as result.

What objects are these tables, they are no "Name"-objects like Named Ranges? How to address them? Btw, I am using Excel 2007, WinXP.

Cheers!

 

[Yard]

MsgBox Worksheets("Sheet1").ListObjects.Count

 

[Roopher]

Dear Yard, thank you very much for the quick help! Thats what I was looking for, great.


Best regards