Results 1 to 5 of 5

Thread: Import TXT files without VBA

  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14

    Import TXT files without VBA

    Hi

    My curiosity, with excel 2016 managing a "Formula / Query" to import the string of a *.txt file.
    Is this possible?

    Thank you all for the suggestions

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    13
    What did you try ?

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Ciao

    I've always imported txt files using vba code, two examples:
    http://excelexperts.com/VBA-Tips-Import-A-Text-File
    https://newtonexcelbach.wordpress.co...iles-with-vba/

    These examples use both VBA codes, looking for alternative methods for reading a .txt file

    If there was not a chance to read the data with a formula I'll give it a reason!

  4. #4
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    13
    A querytable can be created without VBA.

  5. #5
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14
    Hi, snb

    Thanks for the suggestion.
    When opening the Excel spreadsheet, you can set up the automatic txt file update

    Confirm that There is no indirect formula for a txt file
    Thank you

Similar Threads

  1. Convert Text from .txt to columns in excel
    By ravichandavar in forum Excel Help
    Replies: 2
    Last Post: 07-21-2017, 07:35 AM
  2. Replies: 3
    Last Post: 06-07-2017, 05:27 PM
  3. Replies: 15
    Last Post: 08-23-2013, 12:03 PM
  4. Replies: 1
    Last Post: 07-25-2013, 09:03 AM
  5. Xls export to txt
    By marreco in forum Excel Help
    Replies: 4
    Last Post: 12-28-2012, 10:43 PM

Posting Permissions

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