Windows 8, Excel 2013 and Project 2010 - Reference Error in Macro

We have a macro that exports the data from Project 2010 to an excel file. It works well when we use it on a Windows 7 or a Windows 8 machine, but with Office 2010 installed. But now when I am testing it on a Windows 8 Machine with Project 2010 standard but Office 2013, I am getting a Compile error of Cant find the project or Library.

The macro references Microsoft Excel 14.0 Object Library (under VBA menu - Tools - References ) on the machines that it works fine. But on the Windows 8/Office 2013 machine it references to Microsoft 15.0 Object Library. Is this what is causing the error?

Can someone please help me how to figure this error out? How do change the reference or fix the reference?
Thanks