Save XL to PDF on desktop with cell address

There will be two "\\" backslash characters after Desktop as opposed to just one. I suggest to remove the & "\" after MyFullName = DTAddress...

What you can do is add a line after the line shown below so you get to see what the actual file name is

Please Login or Register  to view this content.

So then MyFullName is not initialised properly and you should look at the individual components that should make up the path and name.

Without the actual workbook with the contents I am not able to help you.

Observations:

you are trying to create a directory using the statement below, where the variable MyFullName is blank at this time (not initialised)

Please Login or Register  to view this content.

this is where the error message 'Path not found' comes from. It does not even reach the ExportAsFixedFormat line

I would also add a file extension to the name as shown in the line below

Please Login or Register  to view this content.

What value will MyFullName have when you try to create the directory?

I have deleted the mkdir statement and added the & ".pdf". Ran the code without any problems.

Maybe the below instruction on your PC does not return any value

Please Login or Register  to view this content.

check the value in DTAddress by placing a MsgBox DTAddress instruction just below this statement to see the value returned.

Ok post the new copy of the workbook

See post #13, please post a copy of the workbook

Yes, but you have made changes to it right?

You have removed the statement for creating a directory. The code to create the PDF works, and the pdf gets placed on the desktop.

The example code below creates a new directory named "new_directory_name" on the desktop and because the DTAdress varaible is updated, the pdf will be written into this newly created directory

Please Login or Register  to view this content.