+ Reply to Thread
Results 1 to 5 of 5

OLE Object question

  1. #1
    Forum Contributor
    Join Date
    09-09-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    185

    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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: OLE Object question

    Hello whatsmyname,

    The code you posted assumes the drop down control is already present on the worksheet and fills it if the cell has drop down validation list.
    So, what is relationship between the RXRadioButton and your Drop Down?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    09-09-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    185

    Re: OLE Object question

    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.

  4. #4
    Forum Contributor
    Join Date
    09-09-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    185

    Re: OLE Object question

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

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: OLE Object question

    Hello whatsmyname,

    You have to have Roxio installed on the computer or you will not be able access the libraries.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1