OLE Object question

Hello all I have a piece of code:

Please Login or Register  to view this content.

What my problem is that the OLE Object in Microsoft Excel 2010 is not there. When I open up my workbook and begin to use it and I come to the point to where I need to use my drop down combo box, I get an error saying that the object reference isn't there. I look in my references and find that my RXRadioButton is missing. I know how to fix this by copying my Roxio Shared folder into the appropriate folder. But, I am sending this file to people who are not as savvy. So, my question is, is there a way around this error in Microsoft Excel 2010?

Thank you.

I

I'm sorry, I typed that it wrong. It is the "RXRadioCapture 1.0 Type Library". This is the reference that I find that is missing on all computers running Microsoft Office 2010.

The solution that I have been doing now has been to copy the "Roxio" and "Roxio Shared" folders that I copied off of my Windows XP machine into the "C:/Program Files/Common Files" folder on a computer running either Windows 7 or Microsoft Excel 2010 or both.

I am trying to figure out how to use this workbook on any computer without having to copy that folder onto the computer.

Could it be the data drop down validation list? I built the workbook originally in Microsoft Excel 2003. Could that be the issue?

Thank you for your reply.

Could this be a .NET Framework issue? Or is this a Microsoft Windows XP to Windows 7 issue?