VBA to Save Workbook as pdf

I want to put a button on my sheet that will save the entire workbook as a pdf. I want it to save in the same directory in which the excel file is located and I want it to save with the same file name as the excel file. I am sure this is possible and I wouldn't imagine it would be very difficult but I am have a difficult time with it. Any help would be appreciated.

Thanks!

Try one of these depending on your needs:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks guys. I am almost there I think. What I have works, it just saves the pdf with a .xls in the file name. ie. My file name is Test results. My code will create a pdf titled "Test Results.xls.pdf". This will open properly and I have no problems with it, but it would be nice if there was a way to drop the ".xls" on the pdf file. Take a look at my code below and let me know if you have any ideas.

Please Login or Register  to view this content.

Thanks,
Jeremy

Perfect!

Thanks Paul.