+ Reply to Thread
Results 1 to 3 of 3

better way to import text file

  1. 08-04-2017, 06:26 AM #1
    hendrikbez
    hendrikbez is offline
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    351

    better way to import text file

    I have the following code, is there a better way to do this.

    Import text file int a sheet

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-04-2017, 08:19 AM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: better way to import text file

    Hello
    Attach sample of your text file and show the desired output in excel file to find proper help
    Regards
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 08-04-2017, 08:28 AM #3
    hendrikbez
    hendrikbez is offline
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    351

    Re: better way to import text file

    Here are the link on two screenshots of my text file and how it should look in excel

    https://drive.google.com/file/d/0B87...ew?usp=sharing
    https://drive.google.com/file/d/0B87...ew?usp=sharing
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Export specific range to text file and import the text file if needed
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 07:38 AM
  2. Import a text file by connecting. Select a file by manual.
    By Hakktu in forum Excel General
    Replies: 7
    Last Post: 10-30-2012, 07:14 AM
  3. [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
  4. [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
  5. 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
  6. [SOLVED] Would Like to Automate Batch File Creation and Text FIle Import
    By socrtwo in forum Excel General
    Replies: 2
    Last Post: 08-18-2006, 11:00 AM
  7. 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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1