Error in loading DLL. How to stop this error:

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
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...
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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
 
Upvote 0
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:
Upvote 0
Yes we are cross posting and also found the same link:biggrin:. 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:)
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top