Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vesnabb
Contributor
Contributor

Label in pivot table with chr(10) export to excel dont work

labele : 'Value'&chr(10)&'EUR'

in pivot table is OK --> 2 lines

export in EXCEL with: (in excel file is only in 1 lines ??????)

sub SendToXL
set XLApp = CreateObject("Excel.Application")
XLApp.Visible = True
set XLDoc = XLApp.Workbooks.Add
set tbl = ActiveDocument.GetSheetObject("CH46")
set XLSheet = XLDoc.Worksheets(1)
tbl.CopyTableToClipboard true
XLSheet.Paste XLSheet.Range("A1")
xlsheet.Range("A:A").WrapText = True
end sub



1 Reply
vesnabb
Contributor
Contributor
Author

I attach example !

Please help !

Vesna