I've tried downloading older versions and opening them locally in MS Excel to retrieve the macros but have not had luck so far.

Does anyone know of a solution to this problem?