Number format in macro

upaliwije — Sun, 29 Jun 2014 12:56:30 GMT

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

Re: Number format in macro

MarcoWedel — Sun, 29 Jun 2014 20:18:02 GMT

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

thanks

regards

Marco