Hi All
I am using this macro to extract multiple tables from Qlikview to excel:
http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/comment-page-...
However, I have problems in getting the extracts formatted. I used
WorkSheets("Summary").Row(10).Bold
WorkSheets("Policy").Row(1).Bold
Below. But it does not take.
a) What could I do?
b) What would be the command to wrap a text?
sub exportLosses
'// Array for export definitions
Dim aryExport(3,2)
aryExport(0,0) = "Main"
aryExport(0,1) = "Summary"
aryExport(0,2) = "A1"
aryExport(0,3) = "data"
aryExport(1,0) = "Summary"
aryExport(1,1) = "Summary"
aryExport(1,2) = "A10"
aryExport(1,3) = "data"
aryExport(2,0) = "Policy"
aryExport(2,1) = "Policy"
aryExport(2,2) = "A1"
aryExport(2,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)
WorkSheets("Summary").Row(10).Bold
WorkSheets("Policy").Row(1).Bold
'// Now either just leave Excel open or do some other stuff here
'// like saving the excel, some formatting stuff, ...
end sub
Many thanks.
Best regards,
Jan