Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Error : could not load some object because they are not available in this machine

  1. #1
    New Member
    Join Date
    Apr 2007
    Location
    mumbai
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Error : could not load some object because they are not available in this machine

    Dear All,

    Excel contains Vb Forms, when I open the file on other machine i recd the below mentioned error

    "could not load some object because they are not available in this machine"

    Is there is any solution for above mentioned error

    Regards
    Arulmohan

  2. #2
    Board Regular xl_psychic's Avatar
    Join Date
    Jan 2004
    Location
    A point or extent in space
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error : could not load some object because they are not available in this machine

    Quote Originally Posted by arool.m View Post
    Dear All,

    Excel contains Vb Forms, when I open the file on other machine i recd the below mentioned error

    "could not load some object because they are not available in this machine"

    Is there is any solution for above mentioned error

    Regards
    Arulmohan
    Check if you are using any controls like date pickers or calendars. Mostly such controls are dependant on .ocx files (usually found in the system32 folder on the PC). If these files are not present on the system and/or not registered on the system properly you may get such errors while using VBA userforms in Excel.

    Hope this helps.
    Thank you

    Regards,
    XL_Psychic
    -----------------------------
    OS: Win 7 with Excel 2007

  3. #3
    New Member
    Join Date
    Apr 2007
    Location
    mumbai
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error : could not load some object because they are not available in this machine

    how should i overcome these problem

  4. #4
    Board Regular xl_psychic's Avatar
    Join Date
    Jan 2004
    Location
    A point or extent in space
    Posts
    359
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error : could not load some object because they are not available in this machine

    You'd first need to determine which of the objects are not being loaded up. Then figure out which .ocx files are linked to it.

    For eg: Date Time Picker controls are linked to mscomctl.ocx and mscomct2.ocx files. Calendar controls are linked to the mscal.ocx file

    Once you know which .ocx files are required search for their presence on your machine. If not available you can easily get them on the net. Once downloaded and scanned for any potential viruses (internet - can't really believe what's out there) copy paste them in your system32 folder usually C:\WINDOWS\system32 or C:\WINNT\system32.

    Go to Start run and type the following command to register them in the system

    regsvr32 c:\winnt\system32\mscal.ocx - Replace mscal.ocx to any other .ocx file that you were missing.

    Hope this helps.
    Thank you

    Regards,
    XL_Psychic
    -----------------------------
    OS: Win 7 with Excel 2007

  5. #5
    New Member
    Join Date
    Jul 2010
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error : could not load some object because they are not available in this machine

    Thanks Psychic

  6. #6
    New Member
    Join Date
    Jan 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error : could not load some object because they are not available in this machine

    I have this problem in my pc. I checked mscal.ocx, mscomctl.ocx and mscomct2.ocx files are available on C:\WINDOWS\system32. Once I received this message, it doesn't show me which .OCX files are missing. Any way to find out which .OCX file is missing and which location. Any suggesstion / solution please.

    Thanks

    Nazrul

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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