Hi,
I have the code below which works when I put the full filepath ("C:\Users\Steve\Desktop.. etc..") after the word 'Open' in the last line but I want to have the code refer to cell H42 for the full path instead - my attempt below doesn't work, can anyone put me right, am sure it's a basic syntax thing!
Thanks
I have the code below which works when I put the full filepath ("C:\Users\Steve\Desktop.. etc..") after the word 'Open' in the last line but I want to have the code refer to cell H42 for the full path instead - my attempt below doesn't work, can anyone put me right, am sure it's a basic syntax thing!
Thanks
Code:
Dim objPPT As Object
Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True
objPPT.Presentations.Open Sheet91.Range("H42").Value
Last edited: