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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[neetharao]

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

Please Login or Register  to view this content.

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

[neetharao]

I tried changing that and the error pops out in some other place. I am attaching the original complete code for your reference. It would be great if you could help me out with this.VBA Code.txt

Thanks..

[:) Sixthsense :)]

Sorry I don't have that much of time to study and test the whole code.

So please try to test it from your end and let us know the line of code where the error pops up.

[neetharao]

Ok, sure no problem.

After changing the declarations to Object now i get the error on this line -

Please Login or Register  to view this content.

even if i change the path the same Missing Reference error shows up.

[:) Sixthsense :)]

I suspect the + needs to be replaced with &

Because + should be used with Numbers alone.

To join the texts use & symbol

[neetharao]

I dont think the + is causing the error, because even after changing the path also the error shows up.

It is pointing to the "Missing: Microsoft Powerpoint 15.0 Object Library" only

[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.