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