VBA code to extract strings
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
kjlkhkashdkahskdhaskdhaskdhkasdhkashdkashdkashdkashdkashdkashdkashdkashdkas hdkash
naksdhaskjdhkashdkashdkashdkashdkjashdkjashdkjashdkjashdkasjhdkajshdkas
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!!!!!!