paul_taylor
New Member
- Joined
- Feb 15, 2011
- Messages
- 33
I'm pulling multiple tables from SQL Server into Excel.
When you do this manually through Data > Connections, Excel will convert the data results into a table, using the new 2007 structured references. This is what I want.
But I'm creating the tables automatically through VBA because I need to tweak the SQL code for each table, and the easiest way to do this seems to be through VBA.
When I create the table with the VBA code, the results come in as a named range. Not the new table method. When I go to manually convert the ranges to tables, Excel won't let me.
Can this be done?
When you do this manually through Data > Connections, Excel will convert the data results into a table, using the new 2007 structured references. This is what I want.
But I'm creating the tables automatically through VBA because I need to tweak the SQL code for each table, and the easiest way to do this seems to be through VBA.
When I create the table with the VBA code, the results come in as a named range. Not the new table method. When I go to manually convert the ranges to tables, Excel won't let me.
Can this be done?
