Missing object library

[hnvalton]

Im developing some vba code in excel 2000. I need the PowerPoint object library.
Ok, Ill go and select it from the tools -> references and choose Microsoft PowerPoint 9.0 Object Library.

When im done with the project it´s ok and running fine on excel 2k. Then I run it on excel XP. Everything is still fine.
Now lets take it back to excel 2k. Now in vba tools -> references I have: MISSING: Microsoft PowerPoint 10.0 Object Library.

XP somehow seems to force the Ppt objet library to version 10. Is there a way to avoid this or to make it change back to 9.0 in excel 2k?

Greatly appreciate any help.

 

[Dick Kusleika]

hnvalton

It seems that those references can upgrade themselves (from 9 to 10) but
cannot, and will not, go back. If your macro will be used with different
versions of PowerPoint, you should use late binding (you're currently using
early binding). Here's a discussion of late binding vs early binding as it
relates to Excel and Outlook, but it should be easy to understand from a
PowerPoint perspective.

http://www.dicks-clicks.com/excel/olBinding.htm

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

Im developing some vba code in excel 2000. I need the PowerPoint object library.
Ok, Ill go and select it from the tools -> references and choose Microsoft PowerPoint 9.0 Object Library.

When im done with the project it´s ok and running fine on excel 2k. Then

I run it on excel XP. Everything is still fine.

Now lets take it back to excel 2k. Now in vba tools -> references I have:

MISSING: Microsoft PowerPoint 10.0 Object Library.

XP somehow seems to force the Ppt objet library to version 10. Is there a

way to avoid this or to make it change back to 9.0 in excel 2k?