Export the sheets to PDF Format which has the word "Summary" in Sheet Names

Team,

I need to export the sheets to PDF Format which has the word "Summary" in Sheet Names.

Could anyone suggest me how to implement this Scenario.

Example:

If 10 Sheet Names have word "Summary" then we need to have 10 PDF files need to be generated for these each sheet.

If not possible We can export to Single PDF file with all these 10 sheets.

Thanks!

Kiran

Hi,

maybe this will help you:

Please Login or Register  to view this content.

Hi,

I Tried the above Code but when I ran the Macro it is not asking me to Save the PDF Files.

Thanks!
Kiran