Hi all,
i'm trying to open a PP template (which is on the desktop), but i can't get it to work:
Explicit Option
Sub open_desktop_template()
Dim PP_template_file As String
PP_template_file = CreateObject("WScript.Shell").specialfolders("Desktop") & "\my_template.pptx"
If Dir(PP_template_file) <> vbNullString Then
Presentations.Open(PP_template_file)
Else
MsgBox "template is not on desktop"
End If
End Sub
i think it's obvious that i just started to mess with Excel-to-PP vba
PS: question also posted over OzGrid (no answer).
Bookmarks