Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Error in loading DLL. How to stop this error:

  1. #1
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Error in loading DLL. How to stop this error:

    The following are checked from refereces.
    Microsoft:ref edit control
    Miscrosoft forms edit control
    Visual Basic for applications
    Microsoft Excel 12.0 Object Library.
    OLE Aotomation

    Whenever i open this vba(alt+f11) or try running any of my vba i get this error..
    Error in loading DLL. I cant view any of my vba codes now from this file...
    And moreover when i try to uncheck any of this refereces it wont allow me...


    Please tell me what to do. I have done searches but wont tell me what to do to solve this problem...
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  2. #2
    Board Regular
    Join Date
    Jul 2009
    Location
    Lancashire, England
    Posts
    1,249
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error in loading DLL. How to stop this error:

    Hi Pedie,

    I don't know how to help, are any references marked as missing.
    These are references, that are checked on my copy of XL2007.

    Visual Basic For Applications
    Microsoft Excel 12.0 Object library
    OLE Automation
    Microsoft Office 12.0 Object library
    HTH
    Brian.

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    Xl 2007 & 2010 Win 7

  3. #3
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error in loading DLL. How to stop this error:

    Hi Brian, i was typing and then i lost connection so took longer to reply back sorry.

    when i check the referencees the 6th one that was checked was "MISSING: ref edit control" & the path i see below is "C:\Program Files\Microsoft Office\Office12\REFEDIT.DLL" which is there when i followed the path and cross checked.

    Thanks.

    PS: Related link. same prob but not the resolution.
    In this workbook i have a userform and so many codes like 20 of them for diff controls. This is the only workbook which has this problem. moreover when i un check this missing ref edit... it goes back by itself checked...
    Last edited by pedie; Nov 11th, 2010 at 10:45 AM.
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  4. #4
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Error in loading DLL. How to stop this error:

    HTH, Peter
    Please test any code on a copy of your workbook.

  5. #5
    Board Regular
    Join Date
    Jul 2009
    Location
    Lancashire, England
    Posts
    1,249
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error in loading DLL. How to stop this error:

    I'm not sure from your answer if you have solved the problem?
    If not this may help.

    http://www.excelforum.com/excel-prog...ading-dll.html


    EDIT: We were cross posting, see link.
    Last edited by meldoc; Nov 11th, 2010 at 10:51 AM.
    HTH
    Brian.

    - Posting guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    Xl 2007 & 2010 Win 7

  6. #6
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    INDIA
    Posts
    3,875
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Error in loading DLL. How to stop this error:

    Yes we are cross posting and also found the same link. I think the main problem becuase i have this file from office and now it is working in different computer and excel versions....

    Hi Peter, the link that you suggested is usedfull i read through and i think it is better not to do any thing and let this file go....once i'm back in office it should be okay there...

    Thanks again guys.

    Regards
    Pedie
    Regards,
    Pedie
    MS OFFICE 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  7. #7
    New Member
    Join Date
    Jun 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs up Re: Error in loading DLL. How to stop this error:

    Quote Originally Posted by pedie View Post
    The following are checked from refereces.
    Microsoft:ref edit control
    Miscrosoft forms edit control
    Visual Basic for applications
    Microsoft Excel 12.0 Object Library.
    OLE Aotomation

    Whenever i open this vba(alt+f11) or try running any of my vba i get this error..
    Error in loading DLL. I cant view any of my vba codes now from this file...
    And moreover when i try to uncheck any of this refereces it wont allow me...


    Please tell me what to do. I have done searches but wont tell me what to do to solve this problem...

    Solution for some similar problem:
    Note:

    After the windows security updates we may encounter this error.

    "Error in loading DLL" ...The solution would be to reinstall the application.

    The reason is because of the codes
    MsgBoxStyle and
    MsgBoxResult used in your application.

    If your application uses any of these old VB 6.0 keywords, then during windows security updates we get this error.

    So when you replace this code with some other option then this error would be avoided.

    Please let know when some one has faced such a problem and it worked well.

    Cheers
    Amd

Some videos you may like

User Tag List

Tags for this Thread

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
  •