Quote:
How do I change the coding in order to work this macro enabled excel 97-2003 worksheet (.xls)file in latest version MS office 13
Basically, you don't.
Excel 2013 understand the .xls file in format "Excel 97-2003", macros included. I have the situation every day.
Without the macro and place of exception, it will be complicated to solve your problem.