hey guys
i have many file text which i want to open in an excel workbook in a way that each text file will be displayed in an excel sheet.
is that doable? thanks for your help in advance
regards
hey guys
i have many file text which i want to open in an excel workbook in a way that each text file will be displayed in an excel sheet.
is that doable? thanks for your help in advance
regards
Last edited by mehdoush; 04-03-2009 at 01:06 PM.
any help plz ???
Hi
save the attached file in the folder containing text files and run the macro
Ravj
thank you so much ravishankar
regards
Hi,
I tried using the macro udated in the forum. But i get an error , I have attached the Print screen of the error. Please can you help me out in resolving the issue.
Regards,
Santhosh
Hi
try altering this code to
also look for characters in the filename which your error message suggestsPlease Login or Register to view this content.
I tested the macro again and it is working OK
ravi
Hi Ravi,
It's really good. Is there a possibility to take txt files from any particular drives / folders?
Thanks
ravi
Hey guys
This is a bit late but here goes...
Is it possible to format this code, such that i can get all the text files in new columns and NOT in new sheets? And also is it possible to, say... give a column gap after every 32 files? I have loads of .txt files with no delimiters, so its difficult to get the data into new columns. I just want each new file to start in a new column, (and they all have only one row of data), and after 32 such columns there has to be an additional column left empty, and the next 32 files loaded.
Thanks, in advance!
Scytheslash,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks