Save PDF - Select file location

Hi Guys,

I already have a code below which perfectly to save an excel sheet as a pdf file. But the problem is it saves it in a set location as specified in the code, what I want to achieve is to be able to bring up a promt box to select the location to save this PDF to. I'm sure it is a simple code edit, but I am fairly useless when it comes to coding and couldn't find it anywhere on the internet (perhaps due to rubbish search terms).

Any help is very much appreciated.

Please Login or Register  to view this content.

Works tremendously.

Thank you very very much hulpeloos