Number format in macro

[upaliwije]

Hi

sub exportToExcel_Variant2

'// Array for export definitions

Dim aryExport(1,3)

aryExport(0,0) = "objTX02"

aryExport(0,1) = "Seylan_Card_Summary"

aryExport(0,2) = "D1"

aryExport(0,3) = "image"

aryExport(1,0) = "objSummary"

aryExport(1,1) = "Seylan_Card_Summary"

aryExport(1,2) = "A4"

aryExport(1,3) = "data"

Dim objExcelWorkbook 'Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

end sub

Pls help me write the code to format the Number in range(A4:J20)   with thousand separator in the excel sheet exported through above macro

Thanks in Advance

[MarcoWedel]

could you please add your QlikView specific requirements to your thread?

thanks

regards

Marco