+ Reply to Thread
Results 1 to 3 of 3

Unable to Access Code Due to Bad PPT Library Ref 'Error in loading DLL'

  1. #1
    Registered User
    Join Date
    11-22-2015
    Location
    Oxford, MA
    MS-Off Ver
    2013
    Posts
    2

    Unhappy Unable to Access Code Due to Bad PPT Library Ref 'Error in loading DLL'

    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).
    Last edited by aamailhot; 01-12-2016 at 03:38 PM.

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Unable to Access Code Due to Bad PPT Library Ref 'Error in loading DLL'

    Hi aamailhot and congratulations on your first post,

    You're problem is probably related to the use of 'Early Binding' which requires the Library references. If you change the code a little and switch to 'Late Binding', you can probably work around the problem.

    See the following link which just happens to have a PowerPoint example: http://peltiertech.com/Excel/EarlyLateBinding.html

    Here is a different example, which uses slightly different syntax when using 'Early Binding': http://excelmatters.com/2013/09/23/v...-late-binding/

    Most of the literature prefers Early Binding, because more resources are available such as predefined constants, and use of Intellisense in the VBA editor. I prefer 'Late Binding' even though I have to provide values for predefined constants, because of the problem you just encountered.

    I hope this helps.

    Lewis

  3. #3
    Registered User
    Join Date
    11-22-2015
    Location
    Oxford, MA
    MS-Off Ver
    2013
    Posts
    2

    Re: Unable to Access Code Due to Bad PPT Library Ref 'Error in loading DLL'

    'Very informative LJMetzger, and an interesting design choice I have to make going forward that I wasn't aware of previously.

    Thanks much.

    - Aa

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to delete unwanted backup files after third backup?
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2014, 10:11 AM
  2. [SOLVED] error loading type library/dll
    By molesy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2013, 05:14 PM
  3. [SOLVED] Unable to attach a file error code 407
    By moppyau in forum Suggestions for Improvement
    Replies: 2
    Last Post: 04-30-2013, 05:36 AM
  4. UCase causes "Unable to open project or library" error
    By valkok in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2011, 06:05 AM
  5. Adding library references with code -> error 1004
    By cyc1120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2008, 12:29 PM
  6. Unable to Copy Add-in To Library Error
    By John Hutcins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2006, 01:40 PM
  7. Unable to find project or library - Please help.
    By krayten in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2006, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1