Hi there,
I am receiving the "Error in loading DLL" message when trying to access my VBA code; I can't run it and I can't even open up the code to edit or change my library references :'(. I am pretty sure this situation is due to a Powerpoint Library Reference issue as follows:
1) I had a VBA macro that writes Excel data to Powerpoint that was working fine on computer A with Excel 2013 and 'Microsoft PowerPoint 15.0 Object Library'.
2) I moved this workbook to computer B, which of course was using Excel 2010. Diving into my VBA library references, the PPT library now reads "MISSING: Microsoft PowerPoint 15.0 Object Library".
3) I read up on the issue some and see that I have the 14.0 PPT listed in my Excel 2010 machine. Naturally, I tried selecting the 14.0 and deselected the 15.0 one, however upon hitting 'Ok' in the References window I get the same error: "Error in loading DLL". I go back to my references and the list has reverted so that the (incorrect) 15.0 library is checked off again. I have also tried just unchecking the 15.0 library and not checking the 14.0 one; same behavior.
Much appreciation in advance for helping me out of this awkward situation,
-Aaron
EDIT: One other interesting piece of behavior is that I get that same "Error in loading DLL" message three times upon initially opening my VBA window (alt+F11) on computer B. The window will open after the third time but I am unable to bring up any VBA modules to edit (even ones that I am certain do NOT use the PowerPoint library). If I then close the VBA window and reopen it, I do not encounter any more "Error in loading DLL" messages (until I try to run/edit code).
Bookmarks