PDF Macro Ignores Print Area and File Name

Macro I have to save sheets as a pdf has a minor issue. One is it ignores print areas even though I tell it not to and second it adds .xlsm to the end of file names and I don't want it to add anything. Here's the code I have, any reasons why it does this?

Please Login or Register  to view this content.

Remove UsedRange if you want to use the PrintArea. The Debug.Print shows the printarea in the Immediate window after a run.

Please Login or Register  to view this content.

Thanks, print area and name is fixed but for some reason it now saves to my desktop instead of the file path I give it. Any idea why?

Please Login or Register  to view this content.

Misread problem.

I don't see how. You did not include the backslash after FilePath so it tried to save to the root of your c: drive. That errors for me.

Please Login or Register  to view this content.

Of course c:\Filepath\ must exist or it will error.

The backslash was the issue, File path was just a place holder for the forms. Thanks