Import Multiple Text Files Into Single Worksheet
Hi All,
I have 150 .txt files that I'd like to import into a single worksheet.
The .txt file is an article.
Ideally, I'd love to have each .txt file imported like this:
Title of article in Column A >>> Rest of article in Column B
Is there a quick way to import these files (and hopefully separate the title/article)?
Thanks so much!
-Coz
What is the title of your article in your example ?
Hello cozandeffect,
This macro will read all text files in a specified folder. The first line is assumed to be the title of the article. This will placed in "A1" on "Sheet1". You can change the starting cell and sheet name to what you are using. These appear in bold type. The remaining lines are placed in column "B".
Copy Text Files to Worksheet
Please Login or Register to view this content.
Adding the Macro
- Copy the macro above pressing the keys CTRL+C
- Open your workbook
- Press the keys ALT+F11 to open the Visual Basic Editor
- Press the keys ALT+I to activate the Insert menu
- Press M to insert a Standard Module
- Paste the code by pressing the keys CTRL+V
- Make any custom changes to the macro if needed at this time.
- Save the Macro by pressing the keys CTRL+S
- Press the keys ALT+Q to exit the Editor, and return to Excel.
To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith,
Thank you for your in-depth response.
I notice the title shows up in Column A (excellent!) while the rest of the text shows up in multiple columns (instead of all in cell B1).
Do you know how to move all the text into once cell only?
I've attached the workbook with two sheets:
Sheet #1 is what the macro creates
Sheet #2 is what we need it to look like
(Note: I copied the same article twice just for demonstration purposes)
Again, thank you SO much for your help!
Best,
Coz
Hello Coz,
Here is the updated macro. The attached workbook has a button on "sheet1" to run the macro.
Macro Code to Read Text Files
Please Login or Register to view this content.
Leith, you are a GOLDEN GOD!Originally Posted by Leith Ross
Hello Coz,
Here is the updated macro. The attached workbook has a button on "sheet1" to run the macro.
Macro Code to Read Text Files
Please Login or Register to view this content.
Thank you, thank you, thank you!
Happy New Year!
-Coz
Hello Coz,
You're welcome and Happy New year!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks