Hello folks,

I am wondering if anyone could help with the following
task.

I have a folder that contains 50 txt files. I want to
create a macro that opens all 50, and then saves them with
the same file name it currently has and capitalizes it
(i.e. save abc.txt as ABC.xls). Ideally, it should be
smart enough to finish when all the txt files are saved as
excel.

I am not sure if this is possible, but I thought I would
throw it out there anyway.

Thanks,

Jason