+ Reply to Thread
Results 1 to 4 of 4

Import text file as UTF-8

  1. #1
    Registered User
    Join Date
    09-14-2014
    Location
    paris
    MS-Off Ver
    2013
    Posts
    8

    Import text file as UTF-8

    I am using the following vba code to import all txt files in the active directory into excel.

    Please Login or Register  to view this content.
    However my txt files are in UTF-8 character encoding. How can I import them using the above code but in UTF-8 code?

    I tried to use this:
    Please Login or Register  to view this content.
    but without success. Your help is appreciated.

    Could you please help me to modify this formula to import txt files in utf-8? thanks

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Import text file as UTF-8

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-14-2014
    Location
    paris
    MS-Off Ver
    2013
    Posts
    8

    Re: Import text file as UTF-8

    it works like a charm!!

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Import text file as UTF-8

    Glad too hear that. Thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. See link for guidance.

    http://www.excelforum.com/forum-rule...rum-rules.html

+ 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. Replies: 7
    Last Post: 10-30-2012, 07:14 AM
  2. [Ask] Import Text file And Call reference path file with Value Range.
    By dha_indra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2012, 11:09 PM
  3. [SOLVED] Import text file from VBA code; import all numbers as text
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-19-2012, 05:19 PM
  4. VBA code to import text file to the fixed excel file
    By wangdian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2010, 10:13 AM
  5. [SOLVED] How do I import text file, analyze data, export results, open next file
    By Geoffro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2005, 04:06 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