Keeping leading zero when exporting to Excel using Macro
Hello QlikView Community,
I have a macro that creates an Excel file with multiple tabs and with it different data sets in each tab. For each tab, there is a column (column L titled AuthId) that has an 9-digit ID number (includes leading zero). In my data, this leading zero is definitely recognized by QlikView (I see the leading zero when I view that field--see picture below). However, this leading zero is dropped when the macro exports the data to the Excel file.
What can I add to my macro script to keep or even add a leading zero to this field?
What it should look like:
This is my macro script for this file:
sub exportToExcel_Variant6 '// Array for export definitions Dim aryExport(2,3) aryExport(0,0) = "objPended" aryExport(0,1) = "Pending" aryExport(0,2) = "A1" aryExport(0,3) = "data" aryExport(1,0) = "objApproved" aryExport(1,1) = "Approved" aryExport(1,2) = "A1" aryExport(1,3) = "data" Dim objExcelWorkbook 'as Excel.Workbook Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)
Thank you in advance for any help. Please let me know what other information I can provide to help resolve this.