Breaking News: Grepper is joining You.com. Read the official announcement!

VBA csv save to UTF-8

Healthy Hippopotamus answered on May 24, 2023 Popularity 7/10 Helpfulness 1/10

answer VBA csv save to UTF-8

VBA csv save to UTF-8

Comment

Sub Encode(ByVal sPath$, Optional SetChar$ = "UTF-8")

    Dim stream As ADODB.stream
    Set stream = New ADODB.stream

    With stream
        .Open
        .LoadFromFile sPath ' Loads a File
        .Charset = SetChar  ' sets stream encoding (UTF-8)
        .SaveToFile sPath, adSaveCreateOverWrite
        .Close
    End With

    Set stream = Nothing
    Workbooks.Open sPath
End Sub

Popularity 7/10 Helpfulness 1/10 Language whatever

Source: itecnote.com

Tags: csv save utf-8 vba whatever

Link to this answer
Share Copy Link

Contributed on May 24 2023

Healthy Hippopotamus

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

VBA csv save to UTF-8

Contents

More Related Answers

VBA csv save to UTF-8

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.