+ Reply to Thread
Results 1 to 2 of 2

Importing txt files from folder into one cell only

  1. 02-28-2015, 06:24 PM #1
    RomesFall
    RomesFall is offline
    Registered User
    Join Date
    02-28-2015
    Location
    UK
    MS-Off Ver
    2009
    Posts
    2

    Importing txt files from folder into one cell only

    I'm looking for a solution to an automation issue I'm having.

    http://www.excelforum.com/excel-gene...cel-cells.html

    The thread above seems to have a solution to the problem I'm seeking, but honestly I don't know.

    Could you tell me if the code in that thread will solve the solution to the problem I have described in the title?

    I am basically looking to Import .txt files from one folder into one cell only each.

    Additionally I have no idea how to implement that code. Is there any way you could point me in the right direction?

    Sorry if this is all so trivial, but I can't find any helpful solutions to this issue since delimiting the .txt files isn't an option and there's no way I can realistically copy and paste hundreds of .txt files by hand and have any will left to keep going! lol

    Thanks very much.

    -RF
    Reply With QuoteRegister To Reply
  2. 02-28-2015, 08:41 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Importing txt files from folder into one cell only

    Are you wanting to import a listing of the txt files that are in a folder or are you wanting to import the contents of all the txt files that are in a folder?

    Access the cmd prompt and navigate to the folder with the txt files.

    DOS command to enter all txt file names into one txt file called filelist.txt
    dir *.txt >filelist.txt

    DOS command to combine all txt files into one txt file called output.txt:
    for %f in (*.txt) do type "%f" > output.txt
    Last edited by newdoverman; 02-28-2015 at 09:47 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    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. Unzip all files in a specific folder and move CSV files to a different specificed folder
    By bfaaborg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2019, 06:55 PM
  2. [SOLVED] automatically importing data from all files in a folder
    By alexcrofut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-10-2014, 03:47 PM
  3. [SOLVED] Importing All Files in a Folder
    By Nolanar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2012, 01:35 PM
  4. Importing multiple data files from one folder into one workbook
    By ArcticC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2011, 12:56 PM
  5. [SOLVED] Importing all the .txt files of a folder in a same WB but in different WSheets
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2006, 12:40 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