topic copy only selected values to excel macro in QlikView

copy only selected values to excel macro

Mon, 04 Mar 2013 09:07:27 GMT

Hi everyone,

I have a listbox and I have for example 3 numbers selected and I only want to copy these numbers to excel.

my code right now is:

ActiveDocument.GetSheetObject("LB07").Restore

ActiveDocument.GetSheetObject("LB07").CopyTableToClipboard true

XLSheet.Paste XLSheet.Range("B2")

XLSheet.Cells.EntireColumn.AutoFit

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.ClearCache

the problem is that this code copys the whole listbox to excel but I only want the 3 selected values to be copyed. How can I do this?

regards

Gysbert_Wassenaar — Mon, 04 Mar 2013 09:11:11 GMT

Use a table box instead of the listbox. Or use an expression aggr(MyField, MyField) for the listbox instead of the field MyField.

Mon, 04 Mar 2013 09:18:37 GMT

ok it is a quiet good workaround but I am not really satisfied. but thanks for your help

regards,