Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a problem with an export to text from a module script.
The script i use is :
Sub ExportFiles
pathcorp="\\server\c$\folder\"
set corp = ActiveDocument.GetSheetObject("CH26")
corp.ExportBiff pathcorp & "Hourly_Sales_per_format.xls"
corp.ExportEx pathcorp & "Hourly_Sales_per_format.txt", 1
end sub
The export has the below form
Fo,Cu,Pr,%
CASHC,44224,0,
HYPFL,875429,0,
HYPMI,266220,0,
PROXI,178635,0,
SUPER,1005441,7674,"13001,15%"
Tot,2369949,7674,"30781,02%"
In the export of excel the dot appears correctly but not in the text.
What can i do to appears the dot in the numbers in the export of the text ?
There are more possible parameter for exports - see APIGuide.qvw
Alternatively you could try other methods like CopyTextToClipboard or used a separate object with special formatting for exports.
- Marcus