What is Object of new Tables in Excel 2010 VBA?

[General Ledger]

Dear All,

For Excel 2010 VBA, what is the Object of the new Tables? It seems to not be Table or DataTable.

I am trying count the number of tables in a workbook, create a Table, and name the Table using the count of tables.

Thanks,

GL

 

[VoG]

This appears quite instructive http://www.aspnettutorials.com/tutorials/controls/data-table-vb.aspx

 

[General Ledger]

Vog,

Not quite what I was looking for.

I have the following code that creates a Table in Excel 2010. You get similar code if you record a macro and select from the Insert tab, Tables group, Table. The keyboard shortcut is CTRL+T.

ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1").CurrentRegion, , xlYes).Name = "Table1"

My problem is naming the new Table as Table1. The name may already exist for another Table in my workbook. I want to make the naming of my new table flexible. I want to count the number of Tables in the workbook. I assume there is a Collection for Tables where I can get the count, similar to getting the count of sheets in a workbook (Sheets.Count). Find the number of Tables, add 1, and name the new Table as "Table"&Count + 1

GL

 

[RoryA]

ListObjects - the clue is in the code.

 

[xenou]

I suspect if you just add the table and let Excel name it, it will be the next one in sequence anyway --> Table1, Table2, Table3

Maybe you can just let it be named this way without trying to get a number yourself.

ξ