PDF Macro Ignores Print Area and File Name

[mstark17]

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.

[Kenneth Hobson]

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.

[mstark17]

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.

[jolivanes]

Misread problem.

[Kenneth Hobson]

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.

[mstark17]

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