Results 1 to 5 of 5

Thread: Import TXT files without VBA

  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    132
    Rep Power
    7

    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
    327
    Rep Power
    6
    What did you try ?

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    132
    Rep Power
    7
    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
    327
    Rep Power
    6
    A querytable can be created without VBA.

  5. #5
    Senior Member
    Join Date
    Oct 2011
    Posts
    132
    Rep Power
    7
    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, 08:05 AM
  2. Replies: 3
    Last Post: 06-07-2017, 05:57 PM
  3. Replies: 15
    Last Post: 08-23-2013, 12:33 PM
  4. Replies: 1
    Last Post: 07-25-2013, 09:33 AM
  5. Xls export to txt
    By marreco in forum Excel Help
    Replies: 4
    Last Post: 12-28-2012, 11:13 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
  •