Roopher
Board Regular
- Joined
- Jul 8, 2008
- Messages
- 73
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!
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!