Pivot Table Drilldown Formatting

Question

Hi,

Double-clicking on a number cell in a pivot table creates a new sheet in the workbook, showing the records included in that number. Sometimes the list doesn't look the way they are in the source data. The drilldown details list is formatted as a named Excel Table, in the default style selected in the workbook.The format is different in 2003 and 2007.

I want compatible for both the versions.

Using vbscript am generating the data in excel.

Visual studio 2003 am using.