Thank you both very much for taking the time to respond - I really appreciate.
Actually I need to do a great deal more than just open the PowerPoint file - but I was just trying to keep my query focused in the first instance. FYI after opening the file, I want to sequentially skip through the slides in the file, and on each slide
(i) identify charts
(ii) for each chart, open the datasheet and make various changes to the datasheet
(iii) then move the location of some shapes to re-align their location relative to the bars (or whatever) in the chart
In response to John Korchok (Hi John)....the GetOpenFilename bit works fine - it allows the user to browse for their file and select it - which allows me to identify the file name and assign the name to the variable 'my_Filename'. The problem is actually opening the file.
I CAN, however, open 'my_Filename' if I use this approach:
Sub Test_6()
'OPEN USER FILE
Hello = "Browse to find your presentation. . ."
MsgBox Hello, , "POWERPOINT UPDATER"
my_Filename = Application.GetOpenFilename(filefilter:="PowerPoint Files,.ppt;.pptx")
Dim MyPPT As Object
Set MyPPT = CreateObject("PowerPoint.Application")
MyPPT.Visible = True
MyPPT.Presentations.Open my_Filename
' I then want to sequentially skip through the slides in the file, and on each slide (i) identify charts (ii) for each chart
' open the datasheet and make various changes to the datasheet (iii) then move the location of some shapes to re-align
' their location relative to the bars (or whatever) in the chart
End Sub
But having opened the file this way, I ground to a halt in trying to even do something simple like, in the first instance, identify how many slides there are in the file by using 'ActivePresentation.Slides.Count'
So I started doing more searching and came across the concepts of 'early binding' and 'late binding' - which was a bit of revelation for a novice like me!! Based on my understanding of these concepts, if I give the Excel macro access to the PowerPoint object library, I could use 'early binding' and the macro could use all the bits in the PowerPoint library without having to things like Dim the PowerPoint file as an Object and set it using Create Object.
So logically then, it seemed that I could use GetOpenFilename to identify the name of the file, and then simply use Presentations.Open Filename:=my_Filename to open it.
So given all that, I am still at a loss as what the missing piece is. (Declaration: if it's not already obvious, my (limited) experience with VBA to date has been writing routines for Excel. This is my first foray into attempting to use VBA with PowerPoint).