Copy specified data from notepad to excel

Can you attach a copy of your workbook? Or at least clarify the following:
Do you need to always loop through all txt files in folder or only those which names are in column A?
Where on the worksheet should the extracted text go to, column C?

Originally Posted by dOOb

Can you attach a copy of your workbook? Or at least clarify the following:
Do you need to always loop through all txt files in folder or only those which names are in column A?
Where on the worksheet should the extracted text go to, column C?

Hello dOOb,

Loop through Only those names in column A. The data should be extracted to column b,c...Etc., depending on the headers in the row 1.

Let me know if this works:

Please Login or Register  to view this content.

Originally Posted by dOOb

Let me know if this works:

Please Login or Register  to view this content.

Thanks for your effort dOOb! But unfortunately this isn't working as expected.

as requested earlier, please find the attached sample sheet.

I found this code on the web and this is working fine for one file at a time and displays the output in a msgbox.

Is it possible to modify the code to loop through a set of files in a folder and fetch the data as an output to an excel sheet as in the sample sheet...

HTML Code: 

Hmm, I tested the code before posting it here and, to the extent I understood your requirement, it does exactly what you said it needs to do.
I'm more than happy to help you troubleshoot this, but will need a bit more than "it isn't working as expected"
In the file you attached, the filename in column A has no extension (.txt), is that the issue perhaps? Step through the code line by line with F8 and check where it fails.
As for modifying the code you pasted, it certainly is possible.

Originally Posted by dOOb

Hmm, I tested the code before posting it here and, to the extent I understood your requirement, it does exactly what you said it needs to do.
I'm more than happy to help you troubleshoot this, but will need a bit more than "it isn't working as expected"
In the file you attached, the filename in column A has no extension (.txt), is that the issue perhaps? Step through the code line by line with F8 and check where it fails.
As for modifying the code you pasted, it certainly is possible.

Thank you for the prompt responses!!
I tried without the extension .txt and the code is running fine and doesn't throw any errors but it isn't fetching any data. When i tried with the extension .txt the code throws error at the line, Set myTxtFile = FSO.OpenTextFile(FilePath, ForReading) 'this reads the file to "memory"

What's the error description?
You definitely need the file extensions for this to work, so either full names (i.e. "filename.txt") in your worksheet, or change this line of code:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Try changing "ForReading" to "1" in the line that gives you the error.
I doubt it's this, but just in case you haven't got the right reference selected, it may be.

Also, this is working with Activesheet, so make sure the right one is active.

This works for me as you can see:
Capture.PNG

Let me know how you get on.

Originally Posted by dOOb

What's the error description?
You definitely need the file extensions for this to work, so either full names (i.e. "filename.txt") in your worksheet, or change this line of code:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Try changing "ForReading" to "1" in the line that gives you the error.
I doubt it's this, but just in case you haven't got the right reference selected, it may be.

Also, this is working with Activesheet, so make sure the right one is active.

This works for me as you can see:
Attachment 511917

Let me know how you get on.

its working perfectly for you... but don't know why its not the same for me. i made all the changes suggested by you yet its not working for me. I get an error on the same statement --- run-time error '53': file not found but all the files are in place.

Originally Posted by sarajun_88

I found this code on the web and this is working fine for one file at a time and displays the output in a msgbox.

Is it possible to modify the code to loop through a set of files in a folder and fetch the data as an output to an excel sheet as in the sample sheet...

HTML Code: 

dOOb,

In this code I see that the output is given in the form of msgbx.. how to get them written to an excel file..

Can u please help me on this? Really sorry about repeated requests..😑

Different method

Please Login or Register  to view this content.

Originally Posted by jindon

Different method

Please Login or Register  to view this content.

Thanks a lot jindon! It's working perfectly.
But my bad there are some portions where the data is like,
EGN: xxx
Hug: xxxxx

In this case I need the header as EGN and paste the data Xxx in the row.

As the code works only if there is ----- these sort of data's are not captured. Sorry for missing on this. Please help me on this...

Then I need to see few sample txt files.

Originally Posted by jindon

Then I need to see few sample txt files.

Please find the attached sample source and output files

Try this

Please Login or Register  to view this content.

Originally Posted by jindon

Try this

Please Login or Register  to view this content.

Thanks a lot jindon! It worked like a magic 😊