Save & Send PDF to Public Desktop

Hello VBA experts!

I have a questions about a macro I am writing and after several hours of searching through forums without resolution I decided to go ahead and post my question here.

My goal is to save a series of set print areas to a pdf on the desktop. I was able to get this to work on my own computer, however, the file will be shared with other analysts and needs to be able to save to any users' desktop. I have tried changing the path to "C:\Users\Public\Desktop\Test Report.pdf" but I get runtime error '1004' message. I will paste the code I currently have below, any help will be very much appreciated. Thanks in advance!

Please Login or Register  to view this content.

Welcome to the board, tfry.

You need to create the directory before you can write to it.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

See the MkDir statement. You can only create one level at a time:

Please Login or Register  to view this content.