Hello All,
I have so many text file in one folder. Now I want to check if the text file name is "a" or "b" or "c", then it will copy and paste to correspondence excel sheets ( Like text file a paste in sheet name a....). all excel sheets are empty. i want to just copy text file and paste in the correspondence excel sheet..
Can anyone suggest a code?
Thanks in advance
Edit: Sorry, forgot to state that this code requires a reference to MS scripting Runtime.
Use the code below in a macro-enabled workbook saved in the folder with your text files. I have assumed that the sheet names are single letters - if that is not the case, then you could replace
with
Please Login or Register to view this content.
Please Login or Register to view this content.Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie,
thanks for your help.
I applied your code in my userform..But it cannot find a text files. can you check it in attachments?..I want to select a folder in userform("In Search"). According to this folder, it will check for text file and copied top the main excel sheets.
I had run my test code from the same folder - so the default worked for me. When you change folders, the code needs to bechanged to allow that:
So, change this line
to this:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks