Force format cells in export to csv

[#1]

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