Save worksheets as PDF

Hi,

I am currently using the macro below. However, instead of this macro, I would like to make a macro that save the separate worksheets as PDF file. No password required and names should be the same as in the macro already written. Can someone help me? Thanks!

Please Login or Register  to view this content.

Hi,
The PDF that I use is not able to be manipulated with VBA,(probably because I cheaped out and picked up a free PDF from the internet), so telling it to save to a specific folder is not possible for me.

Workbooks are usually converted to PDF through the print command,

Here is a code I would use if I wanted to save a sheet to PDF, cleaned up after using the macro recorder

Please Login or Register  to view this content.

PDF programs will save as the name of the saved workbook, if you want to move the saved file to another folder, you may be able to find a code that will do that, GOOGLE "move file to another folder VBA excel" seems to come up with a lot of hits.