Save text file UTF-8 encoded with VBA

by

I found the answer on the web:

Dim fsT As Object
Set fsT = CreateObject("ADODB.Stream")
fsT.Type = 2 'Specify stream type - we want To save text/string data.
fsT.Charset = "utf-8" 'Specify charset For the source text data.
fsT.Open 'Open the stream And write binary data To the object
fsT.WriteText "special characters: äöüß"
fsT.SaveToFile sFileName, 2 'Save binary data To disk

Certainly not as I expected…

More Related Contents:

  1. VBA : save a file with UTF-8 without BOM
  2. Loop Through All Subfolders Using VBA [duplicate]
  3. Can VBA Reach Across Instances of Excel?
  4. Efficient way to delete entire row if cell doesn’t contain ‘@’ [duplicate]
  5. Too few parameters Expected 1, recordset issue
  6. Deleting a file in VBA
  7. Save attachments to a folder and rename them
  8. Building Undo Into an Excel VBA Macro
  9. Best workaround for VBA Transpose array length limit?
  10. I use OR to form a multiple condition IF ELSE statement on VBA, it’s not working
  11. VBA- variable in a range, inside a formula
  12. How to Lock the data in a cell in excel using vba
  13. Check for the senderEmailAddress
  14. Removing a string that includes CRLF characters from body of e-mail
  15. Workbooks.Open Method in VBA
  16. Windows().Activate works on every computer except one
  17. How to highlight a cell using the hex color value within the cell?
  18. VBA: How long does On Error Resume Next work?
  19. Exporting MS Access Forms and Class / Modules Recursively to text files?
  20. How can I assign a Variant to a Variant in VBA?
  21. VBScript to open a dialog to select a filepath
  22. How can I create text files with special characters in their filenames
  23. Open a workbook from VBA and disable Workbook_Open() code?
  24. Creating form programmatically in the module using vba
  25. Repeating Microsoft Word VBA until no search results found
  26. Macro to update all fields in a word document
  27. How to filter listbox values based on a Textbox value
  28. Find and FindNext for Excel VBA
  29. Copy an array reference in VBA
  30. How do I get a list of unique values from a range in Excel VBA?

Leave a Comment