Convert file to pdf regardless of user

[KhallP]

I tried to create a procedure whose objective is to convert the excel spreadsheet to pdf and save it in the folder "D:\Users\(UserName)\Documents\Project\(MachineName)", this program will be used by several users on different computers , how can I make the PDF be saved in the documents regardless of the user who is accessing it?



Available folders to save the file depending on the MachineName variable:

My Sub for convert file to PDF:

The file format must remain the same (MachineName, "Date of Today")

 

[KhallP]

That's actually your code as you posted it. I didn't notice that you broke it onto two lines but didn't put a line continuation character in. I've amended my version above.

and can you make me a code that if the file already exists the next file is called "file1 (2)" and onwards?