I'll try Microsoft Scripting for writing and reading text files and see how I get on. This is the link:
https://msdn.microsoft.com/en-us/lib...=vs.84%29.aspx
Not sure how the text is read into Excel but there should be a way.
Thank you.