If you go into the VBE and go to Tools-->References in Excel 2010, you'll see that one is listed as "missing". Go back to Excel 2007 and check there to see which it is. From there you should be able to select it in Excel 2010 and that should solve your issue.
Out of curiosity, is this on the same or different computers? I'm assuming different ones?