Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ANSI coding in textfile from macro

Hi everyone,

I have this macro (VBScript) in which I export a table into a textfile:

Sub ExportToTextfile

    Set tableObject = ActiveDocument.GetSheetObject("TB01")

    tableObject.Export "C:/TEST.txt",Chr(9)

End Sub

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?

Best regards,

Filip

11 Replies
marcus_sommer

I think it should be a global setting but don't touch the excel-export - but I'm not really sure.

- Marcus

Anonymous
Not applicable
Author

OK - thanks for your help!

Have a nice weekend!