Save File Using a named range as the File Path

I am setting up a file for a couple of clients to use and I need the file path to save the files in to be specified by each individual client.

I have set up a named range for this of 'Filepath'

I have already managed to specify the filename in a similar way (range name 'Filename') and this works OK but it saves to the directory that the excel spreadsheet is saved to.

The macro I use for this is:

Sub pdfsave()

pdfname = Range("Filename").Value

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=pdfname, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
End Sub

I have attached a copy of the file.

Thanks for the reply but I think you may have misunderstood what I need.

The filepath that the spreadsheet is saved in will not necessarily be the one that we need. The one that we need will be typed into a specific cell in the spreadsheet that has been given the range name "filepath" (cell B1 of the 'Path for filesaving' tab in the file attached to the original post.

Brilliant, that is spot on.

Thank you