Hi I have the text below in a notepad file. I would like to extract strings that start with "TKT-" and end with ".xml"


TEXT IN NOTEPAD FILE:

TKT-YHDIDOSOOSD.XML hwew asdajsdasdh asdasdasdas TKT-PYD-JHJHJSDSDSD.XML


UDkhaishdkashdhasdas* asdjasldjlasdasjdlasjdl jasldjlasjdlasjdlasjdlasjdaslkdjlasjdlasjdlasjdlas


kjlkhkashdkahskdhaskdhaskdhkasdhkashdkashdkashdkas hdkashdkashdkashdkashdkashdkash
naksdhaskjdhkashdkashdkashdkashdkjashdkjashdkjashd kjashdkasjhdkajshdkas


ahkjsdhaksj


aslasdjalsjdask TKT-JKSJDKSDJKSJD.XML asdkaskdhaskdhasjhdkashdash TKT-89823483hkshdfkhsd.XML







SO the vba code will paste the following in the cells of a spreadsheet
TKT-YHDIDOSOOSD.XML
TKT-PYD-JHJHJSDSDSD.XML
TKT-JKSJDKSDJKSJD.XML
TKT-89823483hkshdfkhsd.XML

Can someone please help and point me in the right direction? Thanks heaps!!!!!!

'tis very unfortunate the OP is incapable of reading or following any of the forums rules and/or has no respect for those rules nor the time of the very people from which they seek assistance.

Should have a read of this for some kind of understanding.

So no one here wastes their time.

https://www.msofficeforums.com/excel...t-strings.html
http://www.excelguru.ca/forums/showt...xtract-strings
http://www.mrexcel.com/forum/excel-q...t-strings.html
http://chandoo.org/forum/threads/vba...-string.29464/