Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think it should be a global setting but don't touch the excel-export - but I'm not really sure.
- Marcus
OK - thanks for your help!
Have a nice weekend!