0 Replies Latest reply: Nov 2, 2016 11:25 AM by Karen Mujeyi RSS

    Keeping leading zero when exporting to Excel using Macro

    Karen Mujeyi

      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)

      end sub

       

      Thank you in advance for any help.  Please let me know what other information I can provide to help resolve this.