0 Replies Latest reply: Jul 27, 2013 9:30 AM by davewalters RSS

    Force format cells in export to csv

      Dear all,

       

       

      As a complete VBscript novice I am struggling with the output of a macro exporting a table to CSV.

       

      The first column 'serial' contains serial numbers of some hardware.

      When exporting to excel the correct format is kept, f.e.1011231204070350.

      However when exporting to csv via a macro the value is displayed as:

       

           

      1,01123E+15

       

      The macro used for the export is listed below and created with an example on this forum:

       

      Sub Export_Details

      'Download Sheet ojbect data to CSV

      set sObject = ActiveDocument.GetSheetObject("TB01")

      sObject.Export "C:\Export\Details.csv",";"

      End Sub

       

      Any help would be great!

      Thanks in advance,

      Dave