Hi all

It's been a while since I last contributed here, but I hope someone is able to help me.

I have hundreds of subfolders in a main folder.
My aim is to copy all files which have a name stating with "DATA".
The folder which these are to be copied in is call "RESULT".

The only catch is that all the files are LIS files, but I want them to be converted to excel files when the are copied to the "RESULTS" folder.

Any help is much appreciated!

Cheers
Dan