+ Reply to Thread
Results 1 to 6 of 6

UTF-8 encoding

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    9

    UTF-8 encoding

    Hi Everyone,

    I have next code what is working properly. My only problem is that the converted VCF file has ANSI encoding and I need UTF-8 but I can not solve it through VBA. Is anybody has solution for it?

    Please Login or Register  to view this content.
    Thanks & kind regards
    Peter

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: UTF-8 encoding


    Hi !

    You can use under Windows Excel version the ActiveX ADODB.Stream to encode,
    see its documentation on MSDN website and samples on forums …

  3. #3
    Registered User
    Join Date
    03-12-2015
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    36

    Re: UTF-8 encoding

    Heya,

    Another option would be to install Notepad ++ (free). This program also has an encoding function.

  4. #4
    Registered User
    Join Date
    09-05-2014
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    9

    Re: UTF-8 encoding

    Hi!

    Thanks I know and use the Notepad++ but I need an instant solution.

    I found a solution but it tested on MS Office 2013 and not working on my 2016 x64. At the line
    Please Login or Register  to view this content.
    give me a messege: Run-time error '3001': Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-05-2014
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    9

    Re: UTF-8 encoding

    Thank you for all, ADODB solved my problem.
    Last edited by peter.lenkei; 03-26-2018 at 04:19 PM.

  6. #6
    Registered User
    Join Date
    09-05-2014
    Location
    Hungary
    MS-Off Ver
    2016
    Posts
    9

    Re: UTF-8 encoding

    Thank you for all, ADODB solved my problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Encoding
    By fariskhan007 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-07-2017, 10:19 AM
  2. save csv with utf-8 encoding
    By sourabhcsp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2014, 10:23 AM
  3. Replies: 1
    Last Post: 05-23-2014, 05:44 AM
  4. Utf8 encoding
    By reikia2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2012, 03:05 PM
  5. [SOLVED] UTF-8.0 encoding
    By bob808a in forum Excel General
    Replies: 6
    Last Post: 06-14-2012, 08:01 AM
  6. XML encoding
    By InfoGet in forum Excel General
    Replies: 0
    Last Post: 04-07-2008, 10:58 AM
  7. [SOLVED] UTF-8 encoding CSV
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 04-03-2006, 09:40 PM

Tags for this Thread

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