Problem with CreatePivotTable (Excel)

STK

Hi all,

I've a problem with the CreatePivotTable (Automation Control - Excel) Statement because it works only with these Parameters:

xlAppG.ActiveWorkbook.PivotCaches.Add(1,textL).CreatePivotTable('','PivotTable1');

But then the worksheet gets the default name and thats a problem because of the Multilanguage of the Excel Versions in our company

I've tried it with nearly every possible combination but it didn't work. I want to create the Pivot table in the workbook with the name of a text constant

e.g. like:

CreatePivotTable(''+Format(C_INC006),'PivotTable1');
CreatePivotTable(Format(C_INC006),'PivotTable1');

...

Does somebody know how it could work?

Thanks in advance #-o

Savatage

have you looked at: http://www.mibuso.com/dlinfo.asp?FileID=484

STK

Thanks,

no I haven't seen this. But now I've already finished my work, only this problem isn't solved, that's why i want to do it "my" way 8-[

And I want to export the Data into an Excel sheet and Create the table out of it