Print to PDF via vba button Excel 2007? (PLEASE CLOSE, POSTED IN WRONG SECTION)

[tailz]

Hi,

I have the following code to print a certain cell range from a button on my worksheet,

Please Login or Register  to view this content.

I would like to add another button that generates a PDF file rather than print to paper, this way the pdf can be emailed.

Thanks

Tony

[zumbalj]

1. Your code needs to be inside code tags in the future, according to forum rules.

2. I'd use the same code as a base, but instead of printing, choose to Save As > PDF. If you have trouble writing this portion of the code, try recording the macro of saving in that manner to help. Then just add a second button.

[tailz]

I now have the code as per below, which I cobbled together from various sources, however, it automatically creates the PDF named "system3", I would like it to be saved as PDF but have the "Save As" dialogue box appear so that I can manually choose the file name but still have it save as PDF. Any help would be appreciated.

Please Login or Register  to view this content.

Thanks

Tony

[GregM56]

Can't you just enter the name you want in a cell and have the Filename: retrieve it from the cell?