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.
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.