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

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

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