VBscript : transpose simple table to export in excel

[#1]

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