Formatting with macros

schumi1980 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am using this macro to extract multiple tables from Qlikview to excel:

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

topic Formatting with macros in QlikView