+ Reply to Thread
Results 1 to 7 of 7

Could not load an object because it is not available on this machine

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Could not load an object because it is not available on this machine

    I use userforms on the excel application I created. I am using Excel 2010. I gave the application to another user to test and they are getting a Microsoft Forms error "Could not load an object because it is not available on this machine"

    It works perfectly fine on my computer, and I gave it to another individual and they didn't have a problem either. In fact the user that gets the error clicks "ok" and then the userform pops up and works fine. Any ideas?

    Thank you!


    MSForms_error.jpg

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Could not load an object because it is not available on this machine

    What version of Excel does the other user with the error have?

    On the other user's computer, load the workbook and in the VBA menu select Tools\References and report if any checked reference is labeled as missing.
    Last edited by AlphaFrog; 11-22-2013 at 03:49 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Could not load an object because it is not available on this machine

    The other user is also using MS Excel 2010

  4. #4
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Could not load an object because it is not available on this machine

    I can't find the tools/references area that you mentioned..

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Could not load an object because it is not available on this machine

    Quote Originally Posted by schmidt1962 View Post
    I can't find the tools/references area that you mentioned..
    VBA Editor menu
    Tools
    References

  6. #6
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Could not load an object because it is not available on this machine

    Found it. The user did not have the developer tab, so I added to her menu. Then went into view code, tools, references, and she has the same as I do:

    Visual Basic for applications
    Microsoft excel 14.0 object library
    OLE Automation
    Microsoft office 14.0 object library
    Microsoft forms 2.0 object library

    She did say that the error only comes up the first time she tries to open a user form. From that point forward there is no errors when opening the user forms

  7. #7
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Could not load an object because it is not available on this machine

    Quote Originally Posted by schmidt1962 View Post
    Found it. The user did not have the developer tab, so I added to her menu. Then went into view code, tools, references, and she has the same as I do:

    Visual Basic for applications
    Microsoft excel 14.0 object library
    OLE Automation
    Microsoft office 14.0 object library
    Microsoft forms 2.0 object library

    She did say that the error only comes up the first time she tries to open a user form. From that point forward there is no errors when opening the user forms
    I'm out of ideas. Sorry.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Could not load object because it is not available on this machine
    By macdonaldtomw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2014, 10:55 AM
  2. Replies: 1
    Last Post: 02-29-2012, 05:29 AM
  3. Replies: 14
    Last Post: 03-14-2011, 06:04 PM
  4. Replies: 1
    Last Post: 08-28-2009, 07:51 AM
  5. Replies: 1
    Last Post: 06-26-2006, 07:15 AM

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