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,
Dave