+ Reply to Thread
Results 1 to 1 of 1

Help with .txt UTI-8 (Origin:=65001) and how to import it properly

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    1

    Help with .txt UTI-8 (Origin:=65001) and how to import it properly

    Dear Everyone,

    I want to import a .txt UTI-8 file from a file that I select. When I use my code it imports it with the wrong code. I have the following macro and I am very very very lost as to how to insert Origin:=65001 into this code.


    Please Login or Register  to view this content.

    I thought that i could do the most obvious as follows:
    Please Login or Register  to view this content.
    but that didn't work.

    Another possible solution would be to open the .txt file then convert it to ANSI and run my code. When I do this manually, this works. I am not sure how to implement this code into my code above with saving as ANSI.

    Can anyone kindly help?

    Cheers,
    Rocko262c
    Last edited by Rocko262c; 04-28-2017 at 07:52 AM. Reason: need to format better

+ 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. Distance from origin
    By tamskinner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2016, 04:13 AM
  2. Import Wizard - File Origin
    By EchoPassenger in forum Excel General
    Replies: 0
    Last Post: 04-06-2016, 05:25 PM
  3. Change file origin after data import
    By Jonathan9 in forum Excel General
    Replies: 0
    Last Post: 10-16-2013, 12:17 PM
  4. "65001: Unicode" option is missing
    By matis in forum Excel General
    Replies: 0
    Last Post: 12-01-2008, 07:32 AM
  5. Origin Of a Spreadsheet
    By Fuabr84 in forum Excel General
    Replies: 3
    Last Post: 04-04-2006, 10:10 AM
  6. [SOLVED] Text Import Wizard: File Origin Problem
    By Baldbloke in forum Excel General
    Replies: 0
    Last Post: 03-29-2006, 09:55 AM
  7. R^2 value in regression through Origin
    By Hong in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2006, 04:30 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