I have recently been issued with a mathematical model in an Excel spreadsheet. This involves copious numbers of sheets, with many macros and a boatload of VBA behind the scenes.
But the model is rather old and was last known to work on Windows XP, Excel 2003. I am currently using Windows 8.1 and Excel 2013, and it is producing the error message:-
Compile error in hidden module: Automation
twice on starting up and once on closing down; the model doesn't work either although no further error message is produced.
Does anyone know how to fix the problem causing this message to appear? (I suspect the model's failings are related to this.)
No comments:
Post a Comment