Open PowerPoint using Named Range

[roasty_1]

Hi

I am trying to open up a specified PowerPoint presentation.

When I actually write the file path and file name in the code is opens up the file.

However, when I try and open the file using a range created in Excel I get this error
‘runtime error '-2147467259 (80004005)': PowerPoint could not open the file.’

I need to do the range method as the file path changes.

So, why won’t the file open if I use the range method?
Can this be done?

Many thanks

Roasty