Missing: Microsoft Powerpoint 15.0 Object Library

[neetharao]

Hi,

I am working on a macro that copies the data from excel and pastes it to powerpoint. The code works fine in Excel 2013 but throws an error when running in Excel 2010 and sometimes vice-versa.
The error being "Missing: Microsoft Powerpoint 15.0 Object Library"
This reference can be updated manually but is it possible to do that through the same code. The code errors out in the first line itself.

Below given are the declarations that are done in the code:

Dim PPApp As PowerPoint.Application    
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide

Dim PresentationFileName As String
Dim SlideCount As Long

Please help me out from this issue.

Thank you for your help in advance.

[:) Sixthsense :)]

Click Tools>>References>>Locate Microsoft Powerpoint 14.0 Object Library>>Give Tick Mark and Give Ok...

[neetharao]

Thanks for your quick response. But i know the manual way of adding that, i wanted to know a way of adding that through the same code.

Is it possible?

[:) Sixthsense :)]

Instead of thinking in that way change your method of writing the code like the below.

Your current method will require the references needs to be established

Dim PPApp As PowerPoint.Application

But this will work on any machine without the need of any establishment of references

Dim PPApp As Object
Set PPApp = CreateObject("PowerPoint.Application")

[neetharao]

Thanks, that sorted out the first line. What about the other 2 declarations?

Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide

Do i declare them as objects as well?

[:) Sixthsense :)]

Do i declare them as objects as well?

Yes, exactly!

If you declare the variable directly then you have to enable the references.

Otherwise you have to declare the variable as object and set the concerned object as I shown in my earlier post

[Lokerok]

I just have feelings u dont have that library on ur comp. Download and retype the path
w8. My fail. u cant do that... try to refer to 14.0 library after closing program.

How to do:

Look what I did. I dont have 15.0 library, but I have 14.0 . Just go
C:\Program Files (x86)\Microsoft Office
over there create new folder whith name "Office15"
after that copy ALL from ur folder "Office14" to ur new folder "Office15"
reboot ur program

yes. this is fail solution, but it works

[romperstomper]

You should remove the reference. It is not needed since you have late bound your code, and it is causing the problems.