Opening PPT thru XL

[lambuhere1]

Hi

Can we not call PPT from Excel. I am on XL 97 SR2. I wanted to open PPT thru Excel. I tried the following statement, But i get compile error.


Dim pptobj As PowerPoint.Application

Microsoft Office 8 object library is already present.

Can you thinnk why its happening?


Thanks for your help.

Ram P

 

[Oldsoftboss]

Create a hyperlink to jump straigt to the file you want

 

[PearlGI]

You need to have the library

Microsoft PowerPoint 8.0 Object Library.

Then it should work.

 

[lambuhere1]

Hi Pearl

I do have my Object library 8 already set up. Then why doesn't PPT open up thru Excel?

Thanks for your help.

Ram P

 

[PearlGI]

If you're sure you've got the PowerPoint library loaded rather than just the Office library, I'm not sure why you still get a compile error!!

Try the following lines and see if you get the same error.

Dim objPPT As Object
Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True

HTH

 

[lambuhere1]

Thanks Pearl for your help. Error was in Dim statement.

Ram P