Error in loading DLL. How to stop this error:

[pedie]

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...

 

[meldoc]

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

 

[pedie]

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...

 

[VoG]

Hi.

This should help http://www.cpearson.com/excel/MissingReferences.aspx

 

[meldoc]

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

http://www.excelforum.com/excel-programming/681338-error-in-loading-dll.html


EDIT: We were cross posting, see link.

 

[pedie]

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

 

[amdprogrammer]

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