Macro to copy table to excel transposed

[#1]

Hi,

I have a staight table in QV with the Horizontal property set to true, when I copy this table to excel it loses that property. Is there a way to copy the table to excel then transpose it? thanks

[#2]

-4104 : paste all

-4142 : replace values in destination (no calcul)

false : paste blank values also

true : transpose

the first 3 are the default values, but you have to write it to be able to write the fourth one

[#3]

Where do I get these codes? I always use the functions of excel in qlick view.

Like now I'm looking for the code to paste only values

[#4]

that's microsoft macro language

look there for pastespecial function Range.PasteSpecial Method (Excel)