Excel spreadsheet with VBA can't find reference to Powerpoint Library

Posted on 2007-08-10
Last Modified: 2013-11-26
I have an Excel spreadsheet that uses the Microsoft Powerpoint 11.0 Object Library to automatically copy and paste cell ranges and charts to a new powerpoint presentation.

This works on many machines, but the whole spreadsheet falls over on one or two machines that appear to have the same build as those on which it works, but upon which it cannot find the aforementioned reference.

FYI These machines have the same installation of Office 2003.

Is there any good reason for this problem, or do the machines in question just need the Office install repaired or reinstalled?
Question by:ScottRogersGC
    LVL 85

    Expert Comment

    by:Rory Archibald
    Is Office installed in the same location on those machines? Do they get any errors running Powerpoint normally?

    Author Comment

    no errors running powerpoint normally - which is what surprises me

    not sure about location, not easy to find out as the machine is in the US
    LVL 85

    Expert Comment

    by:Rory Archibald
    They don't have multiple versions of Office installed by any chance?

    Author Comment

    almost definitely not - but I will check that as well, they should be getting in the office soon
    LVL 21

    Accepted Solution

    A couple of things to check:
    On the PCs in question, open Excel, Open the VB Editor, click on Tools, Reference and see if the Microsoft Powerpoint 11.0 Object Library is missing.
    Make sure your users haven't installed any add-ins for PowerPoint and/or Excel
    Clicking on Help, Detect and Repair in PowerPoint should restore the registry settings
    LVL 63

    Assisted Solution

    Also check that the path opints to where the powerpoint files are in the OS environment.

    Compare a working and non-working machine via the Set command in DOS.

    I hope this helps !

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now