I am using Widows 7 and excel 2007


I need a macro that will loop thru a directory,open each excel file (.xls) and edit all of the link's in the "Edit Links" box from xls to xlsm and then save the file over writing the original file.


There can be more than one link in the "Edit Links" box but they all have to have the xlsm extension leaving the file name as is.

Thanks