VBscript : transpose simple table to export in excel

Tue, 16 Apr 2013 08:03:39 GMT

Hi,

I want to paste a simple table in excel with a VBscript.

It works perfectly with the code below:

Set objCurrentSheet = objExcelDoc.Sheets(sheetName)

objExcelDoc.Sheets(sheetName).Range(sheetRange).Select

objExcelDoc.Sheets(sheetName).Paste

but then I want to transpose the simple table with the following code :

Set objCurrentSheet = objExcelDoc.Sheets(sheetName)

objExcelDoc.Sheets(sheetName).Range(sheetRange).Select

objExcelDoc.Sheets(sheetName).PasteSpecial Paste=xlPasteValuesAndNumberFormats,Transpose=true

but it does not work

you have an idea?

thank you very much

See the attach file

topic VBscript : transpose simple table to export in excel in QlikView