VBA-print as pdf w/ filename from a cell, & print in folder excel file is located

[wpssnotoq]

Hello VBA bothers and sisters,
I would like to write vba code and then create a button that prints 1 or 2 excel worksheets as pdf and then have the pdf file print in the folder that the excel file is currently located in.
I would like the name of the file to come from a value in a cell A1.
The cell with the file name would come from a separate worksheet then the two sheets I want to print as pdf.
Specifics
1) the file name would come from worksheet named "estimator"
2) The two worksheet that I want to print as pdf are: "catwalk quote PG-1" and "catwalk quote PG-2."
3) I want to place a command button on "catwalk quote PG-1"
4) I want the pdf file to print in the current file path that the excel sheet is located in.
Can anyone help?

Thanks,
Noel

[chareaves]

Hi Noel

I just asked a very similar question yesterday then managed to solve it myself. You'll find my thread with the code here: http://www.excelforum.com/showthread...98#post4569498

My requirements were a bit more complicated than yours so you should be able to easily adapt it. I've commented the code as much as I can. Hope it helps.