Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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!