chandrashekar.shayana
New Member
Hello Friends can any one help me download/ Open PPT file from sharePoint online using the Path
I am using the below code but I am getting the error as "run time error '- 2147467259 80004005 )': method open of object presentations failed"
Sub PPTOPen()
Dim PPT As PowerPoint.Application
Dim fileName As Variant
Dim WS1 As Worksheet
Dim myPresentation As PowerPoint.Presentation
Set WS1 = ThisWorkbook.Worksheets("Sheet1")
fileName = WS1.Range("G5") ' File path given in this range
Set PPT = New PowerPoint.Application
PPT.Visible = True
PPT.Presentations.Open fileName
End Sub
I am using the below code but I am getting the error as "run time error '- 2147467259 80004005 )': method open of object presentations failed"
Sub PPTOPen()
Dim PPT As PowerPoint.Application
Dim fileName As Variant
Dim WS1 As Worksheet
Dim myPresentation As PowerPoint.Presentation
Set WS1 = ThisWorkbook.Worksheets("Sheet1")
fileName = WS1.Range("G5") ' File path given in this range
Set PPT = New PowerPoint.Application
PPT.Visible = True
PPT.Presentations.Open fileName
End Sub