Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Yuby Mona pe Simpatie.ro
 | Femeie
23 ani
Arges
cauta Barbat
23 - 45 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
If you open an excel file and receive a missing DLL message it's usually (or always, dunno) because you use VBA in your file and an Object Library is improperly registered, unregistered or if certain syntax in your VBA code was made in a newer / older version of VBA and not supported by the current version of Office Excel.
If the problem appears simply because you moved the file from a computer to another (even if both with, say, Office 2010) and something happened in between (this happened to me, but dunno what exactly) and you receive the Missing DLL message, can't save your file which needs to be recovered, you can't recover it, then:
- go to Visual Basic Editor (in excel press ALT+F11 or on your Developer ribbon press Visual Basic button)
- go to Tools - References
- see if any entry that is selected is marked as MISSING: eg I had MISSING: Microsoft Word 16.0 Object Library, even though I was using Word 15.0 and the other object libraries (Excel, Office) were 15.0.
- deselect the missing library
- scroll down the list and SELECT the library with the same name, but corresponding to your office version (in my case, I deselected MISSING: Microsoft Word 16.0 Object Library, SCROLLED DOWN AND SELECTED Microsoft Word 15.0 Object Library)
If that doesn't work:
Open a NEW EXCEL FILE first, then go to Options - Trust Center - Trust Center Settings. Make sure Disable Macros with notification is enabled (in Macro Settings), and also make sure you delete the list of trusted files (in Trusted Documents click Clear then Yes).
When you open the file with DLL problem, the line with enable macros should appear - DO NOT CLICK ENABLE - go ALT+F11, no DLL error should appear. Go to Tools - References, deselect the problematic (MISSING) library and select the one corresponding to your version. Click OK, and there should be no more errors.
Close Visual Basic, then reopen it (ALT+F11) and go again to Tools - References to verify that the MISSING file is deselected and the right one is selected.
Now you can save your file. When you reopen it there will be no more problems. You can enable macros and check. After you enable them, the document goes into the trusted list for that location. If you move it to another location, it will ask you again to confirm enabling macros.
*****
This should fix your document and make everything work with VBA.
Unless there is a syntax issue (they changed some formulas in VBA on newer Office versions and those newer versions don't recognize older code anymore - or the other way around).
If there is a syntax issue, well you need to find the corresponding code and change the macros to it.
|
|
| pus acum 6 ani |
|
TonyTzu
Moderator
Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
I then deleted the file from my folder, re-copied it from the email, opened it without any event code having run and changed the references. This worked OK and the file now runs as expected.
The problem seems therefore to be that references in Excel 2013 files cannot be changed after the code that uses the references has run.
[...]
So am I right in assuming that, if the problem should occur when an event happened on opening the workbook, the only way around it would be to disable macros with the file not open, open the workbook, change the references, save it, close it, re-enable macros and then re-open the file? |
|
|
| pus acum 6 ani |
|