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!!!!!!