Hi Purfleet & NoSparks,
Thanks for your reply and looking into it.
The files are needed as separate text file for transmission into a system.
I am not familiar with VBA so would like to seek experts' advice to automate the process through VBA for my company's work. To reduce the manual effort involved
Thank you in advance.