VBA to Export multiple Worksheets to PDF with window to select save location

[Grimm127]

Hi Excel Gurus,

I have a report with several worksheets and I need to export a few to pdf. So I would like to have a macro that selects a group of worksheets (ex: Sheet 1; Sheet 4, Sheet 8, etc) and exports to a pdf. However, I would prefer at the window pops up so I can name the pdf and set where the pdf will need to be saved to. Every month I have to save in an alternate location.

So I would go to file (in the ribbon), Export, Create PDF/XPS Document and click button to get to the window I am looking for.

Thank you all in advance.

 

[DanteAmor]

Download the following app, it has several options to print, pdf and excel.

Send multiple sheets to PDF-Print-File v6.xlsm

drive.google.com