Opening A File From Excel VBA

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Is there a way to open a powerpoint file from excel
without having powerpoint open first?

Thanks,

Julie
 
Sub OpenPowerPntDoc(
Dim PwrPnt As Object, Pres As Objec
On Error Resume Nex
Set PwrPnt = GetObject(, "PowerPoint.Application"
If Err.Number Then Set PwrPnt = CreateObject("PowerPoint.Application"
On Error GoTo
PwrPnt.Visible = Tru
'>>> us this line to open a specific Pressentation file, where MyFilePath = File path & Name, i.e "C:\Pres.ppt
Set Pres = PwrPnt.Presentations.Open(MyFilePath
End Su

----- Julie wrote: ----

Is there a way to open a powerpoint file from excel
without having powerpoint open first

Thanks

Juli
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top