When I import an XML file in Excel 2003 it creates a listobject

'List1'

but in Excel 2007 it creates a listobject

'Table1'

An in my code I unlist the list but since the name changes
(ActiveSheet.ListObjects("Table1").Unlist),..., I don't know how to handle
it. As such, how can I made a more generic code to unlist any and an
listobject found.

Thank you,

QB

If you active cell is in the Table you can use

ActiveCell.ListObject.Unlist



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"QB" <(E-Mail Removed)> wrote in message news:B5A7FB65-FD01-4A24-9E5F-(E-Mail Removed)...
> When I import an XML file in Excel 2003 it creates a listobject
>
> 'List1'
>
> but in Excel 2007 it creates a listobject
>
> 'Table1'
>
> An in my code I unlist the list but since the name changes
> (ActiveSheet.ListObjects("Table1").Unlist),..., I don't know how to handle
> it. As such, how can I made a more generic code to unlist any and an
> listobject found.
>
> Thank you,
>
> QB

Found one possible solution

http://www.microsoft.com/office/comm...4-f339561d1a29

QB





"QB" wrote:

> When I import an XML file in Excel 2003 it creates a listobject
>
> 'List1'
>
> but in Excel 2007 it creates a listobject
>
> 'Table1'
>
> An in my code I unlist the list but since the name changes
> (ActiveSheet.ListObjects("Table1").Unlist),..., I don't know how to handle
> it. As such, how can I made a more generic code to unlist any and an
> listobject found.
>
> Thank you,
>
> QB