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:





      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,