Discussion Board for collaboration on QlikView Scripting.
I have this macro (VBScript) in which I export a table into a textfile:
Set tableObject = ActiveDocument.GetSheetObject("TB01")
My problem is that the exported file has an UTF-8 encoding. I would like to export into ANSI encoding, or convert it into ANSI encoding if possible. Anybody here that knows this?
Solved! Go to Solution.
There are two further parameter after the delimiter-parameter possible - the codepage and appending to an existing file with true/false.
Codepage number, e.g. :
0 = current ANSI
1200 = Unicode
65001 = UTF-8
This works, just tried it.
Set tableObject = ActiveDocument.GetSheetObject("TB28")
Yes, you are correct Marcus!
Thanks a lot!!
But does this setting affect regular export from charts to excel (such as pivot tables) or only text file exports?