VBA code to find partial matching word and export to notepad

[sarkhan_585]

Hello guys. I need your help. Really appreciate your any help. I need to develop a VBA code that I can export the rows which contains a word (example, "Home" )to notepad as a text file. In the Column D there is some information and within this information there is a certain word and I need to find this rows and export. Looking for any help from you. thank you in advance.

[kasan]

Hi and welcome!
As soon as you didn't provide any sample file with data to work with - please find my version attached.
If searched word is found in column D - it will be exported to the txt file.

Please Login or Register  to view this content.

[sarkhan_585]

Thank you Kasan

But I have value from A to N and I want to state filename as following

filename = ThisWorkbook.Path & "/EURindex as of date" & Format(Now, "dd.mm.yy") & ".txt"

How I can do this?

Thank you

[kasan]

This version will export row values from A to N if column D value contains searched word.
I'm not sure how you need to export all those values? Do you need spaces or some symbol between values?
In case you need to separate values from excel file - adjust line of code where variable output is formed.

Please Login or Register  to view this content.

[kasan]

ahh, can't edit post... attachment is right here

[YasserKhalil]

I think that there would be a line to empty output string

Please Login or Register  to view this content.

[kasan]

@YasserKhalil
Yeah, you are right, thanks!

[sarkhan_585]

Yasser that made clear the output. if I want to add special character between each value how I can do that?

[kasan]

Add some character to this line:

Please Login or Register  to view this content.

like:

Please Login or Register  to view this content.

[sarkhan_585]

Thank you all of you! Really you helped me much.

[sarkhan_585]

Kasan, I noticed that the first row where I have the header disappear due to it does not contain a special word. I tried several ways but it shows error. could you help me please

[kasan]

So you need to extract header and then rows with specific word, right?
Add red code.

Please Login or Register  to view this content.