Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
-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
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
that's microsoft macro language
look there for pastespecial function Range.PasteSpecial Method (Excel)