Hi,
I'm trying to create a macro that will import multiple multi line text files.
Am completely stumped.
I have tried another Macro from this site however that imports the each text file into one cell, but i need each line to be in a new cell and each file to be in the same sheet.
attach please a sample text file
are the text file in the same folder ? you have to import all ?
If solved remember to mark Thread as solved
Hi,
Yes they are all in the same folder and all need to be imported.
I have attached a sample text file.
Please Login or Register to view this content.
Last edited by patel45; 04-30-2013 at 08:22 AM.
Thanks for this but is there any chance you can put notes in so i know what i need to change to what?
I am only very basic minded with macros.
You can only change folderPath and drow, see added comments
or
Please Login or Register to view this content.
This doesnt seem to do anything when i run it?
This is what i had but this only pulls in text file on a single line per file where what i want is each line in the file to be on a new line in the spreadsheet, and all files to be pulled into the same spreadsheet.
Please Login or Register to view this content.
Last edited by arlu1201; 02-12-2014 at 10:20 AM.
of course:
Please Login or Register to view this content.
This code works well, but how can it be altered to insert each file into a different column?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks