How to save a PDF from an Excel file with macro in every user

Question

Good evening,

I'd like to know how to export a complete Excel worksheet as a PDF for each user who utilizes it via macro. My issue is that when you record the macro, the last step is to choose where to save the PDF file, which is dependent on the user's path. Can you modify the macro to make it function for every user who uses it? For example (I'm not sure if it's possible to write it in an excel programming environment) read the user's path when the excel file is opened and replace the user name in the save option.)

Thank you in advance!