ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening A File From Excel VBA (https://www.excelbanter.com/excel-programming/296193-opening-file-excel-vba.html)

JUlie

Opening A File From Excel VBA
 
Is there a way to open a powerpoint file from excel
without having powerpoint open first?

Thanks,

Julie

Chris

Opening A File From Excel VBA
 
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



All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com