Hi all,
i am trying to open multiple text files, copy and paste in single excel sheet ( one by one). i am use below code it open all the text file into excel but unable to copy and paste in single excel sheet. can any one help..
Please Login or Register to view this content.
Thanks
Jack
Last edited by arlu1201; 07-23-2012 at 03:53 AM. Reason: Use code tags in future.
I always have to convert TXT into XLS before i can import it into excel.
Please Login or Register to view this content.
Jack40,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
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]
Hi all,
Here is the code for copy data from mulitple text file and paste in single sheet..
Please Login or Register to view this content.
Regards
Jack
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks