open folder in folder A if folder B has same name change na

[excelent]

hi members.

This may be a strange question but can you use excell to open a file from a folder A and automatically search for 4 letter xls file names. select the first lowest value folder name and
remember the file name e.g.AAAA.xls

then search for the same file name in folder B and if it exists rename and save it as a text file (only in folder B) e.g. AAAA.txt.

now repeat this with the next 4 letter xls file name in folder A e.g.AAAC

thanks.
mike.