Hi
I want to open an existing PowerPoint file (nominated by the user) using VBA within Excel. Note that I have added the PowerPoint Object library to 'References' in the macro. The code I am using (see below) I have used before successfully to open Excel files. In this instance, however, I have replaced "Workbooks.Open" with "Presentations.Open". The code successfully allows the user to browse for their file, but when the file is selected, the macro crashes at "Presentations.Open". Can someone pls tell me what I am missing? Thank you in anticipation of your help
'OPEN USER FILE
Dim my_Filename As Variant
Hello = "Browse to find your presentation. . ."
MsgBox Hello, , "POWERPOINT UPDATER"
my_Filename = Application.GetOpenFilename(filefilter:="PowerPoint Files,.ppt;.pptx")
If my_Filename <> False Then
Presentations.Open Filename:=my_Filename
End If