View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
raph_baril[_2_] raph_baril[_2_] is offline
external usenet poster
 
Posts: 5
Default open powerpoint file

Yes I made it up, it works perfectly when you replace "document" by
"presentations"
Thanks!!!

"Chip Pearson" wrote:

The PowerPoint object model doesn't have a Documents object. Did
you just make it up? Try

Set Potato = Brocoli.Presentations.Open(filename:=carot)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"raph_baril" wrote in
message
...
I want to open a power point file with the following code but
it's always
giving me an error on the last line. Somebody knows?

Sub openppt()

Dim Brocoli As Object
Dim Potato As Object
Dim carot As String

carot = "C:\random folder\open me.ppt"

Set Brocoli = CreateObject("powerpoint.Application")
Brocoli.Visible = True

Set Potato = Brocoli.documents.Open(Filename:=carot)

End Sub