Call a .pps from excel

[Qroozn]

How can i call a powerpoint show to open from an excel macro.

I have tried using
microsoftappl.xlpowerpoint

or something similar... but it just opens a new presentation.

TIA

 

[Parra]

Sub DisplayWordAutomation()
Set wordapp = CreateObject("Word.Application")
'WordApp.Application.Visible = True
With wordapp
.Visible = True
.Activate
.Run (" type macro name here ")
.Quit SaveChanges:=wdDoNotSaveChanges
End With
End Sub

Here is a macro I use to open word from excel and then run a word macro. I would just change the word stuff to powerpoint and create a macro in powerpoint to open the file you want and type that macro name in the macro above (no spaces when you type the name). Let me know if it works.

 

[Qroozn]

but if i am simply trying to open a file do i really need to open one application (.ppt) to open another application(.pps)

there must be an easier way.

 

[Parra]

I am not sure I understand.

You are trying to open Powerpoint in Excel.

Or

Start a Presentation in Powerpoint.

 

[Yogi Anand]

Hi Qroozn:
I just wanted to jump in on the issue of *.ppt vs *.pps

A file that has a pps (powerPoint show extension) will automatically begin to play -- without having to first open the file and then SlideShow|ViewShow

otherwise a .pps file is the same as .ppt file.

Regards!

Yogi Anand

 

[Parra]

Good Idea Yogi, I did'nt think about that.

Parra

 

[Qroozn]

I understand that yogi.. thats why i named the file as .pps
but surely (hopefully) there must be a different way of opening the file then to open ppt application, and call a macro from ppt which then runs the pps file.

 

[Qroozn]

sorry.. my fault. I will explain a bit clearer.

I have an excel program. and i also have a powerpointpresentation about the program.
I want to click on a button in excel and have it run the powerpointshow.

I hope that is clearer

 

[brettvba]

make a hyperlink that will run it

 

[Yogi Anand]

On 2002-05-06 18:15, brettvba wrote:
make a hyperlink that will run it

Yes brettvba! I do it all the time.