View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Question on using Form's Button in Excel

Sure it can

Set pptApp = CreateObject(,"Powerpoint.Application")
pptApp.V isible = True
pptApp.Presentations.Open FileName:="c:\My Documents\pres1.ppt"

--
HTH

-------

Bob Phillips
"Bert" wrote in message
...
Jeff,

Thanks so much, it worked. I have another question. Can a
powerpoint file be opened up thru this CommandButton in
excel (First open up powerpoint then open up the file I
need).

Thanks,

Bert

-----Original Message-----
Hi,
Yes, one way:

Private Sub CommandButton1_Click()
callppt
End Sub

Sub callppt()
x = Shell("C:\Program Files\Microsoft Office\Office10
\POWERPNT.EXE")
End Sub

jeff
-----Original Message-----
I use a button in Excel to call a file into Excel. Can I
use a button in excel to open up another Office
application such as Powerpoint?
.

.