export a chart to text from module script

geogou1973 — Mon, 16 Dec 2013 10:01:59 GMT

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 ?

Re: export a chart to text from module script

marcus_sommer — Mon, 16 Dec 2013 16:56:52 GMT

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