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











LinkBack URL
About LinkBacks
Register To Reply
Bookmarks