Results 1 to 2 of 2

UTF - 8 Special CHaracters HELP!!

Threaded View

joaobmx UTF - 8 Special CHaracters... 09-19-2014, 09:25 AM
Gregor y Re: UTF - 8 Special... 10-03-2014, 03:54 PM
  1. #1
    Registered User
    Join Date
    07-13-2014
    Location
    Portugal
    MS-Off Ver
    2010
    Posts
    8

    UTF - 8 Special CHaracters HELP!!

    Hello everyone

    I have this code that exports to the UTF - 8 format perfectly, But what happens is that when it is exported can not read the special characters.
    Can anyone help?

    This is the code i wrote:

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    Sub Encode3()
    Const sPath As String = "C:\temp\d.Txt"
    Const SetChar As String = "UTF-8"
    With CreateObject("ADODB.Stream")
    .Type = 2
    .Open
    .LoadFromFile sPath ' Carrega o ficheiro
    .Charset = SetChar ' passa o ficheiro para (UTF-8)
    .SaveToFile sPath, 2 ' grava por cima
    .WriteText "special characters: äöüß" ' caracteres especias
    .Close
    End With
    End Sub
    Last edited by 6StringJazzer; 09-19-2014 at 02:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vba sql special characters
    By Jollyfrog in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-26-2014, 06:49 PM
  2. Macro to replace European characters with non "special" English characters?
    By johanna0507 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 09:13 AM
  3. special characters
    By glen.e.mettler@lmco.com in forum Excel General
    Replies: 1
    Last Post: 04-03-2006, 03:10 PM
  4. [SOLVED] Special characters
    By Matthew S in forum Excel General
    Replies: 10
    Last Post: 09-23-2005, 08:05 PM
  5. special characters (little box)
    By YuChieh in forum Excel General
    Replies: 9
    Last Post: 06-14-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1