Hi,

Is there any way to convert the excel file into PDF when I will save and close that excel file ?

For example, I want to run a macro whenever the opened excel file will be saved and closed, that particular file will be converted into PDF by default. This will be applicable for all sheets available in that excel file, say there are 3 sheets available in the file and when the excel file will be converted into PDF three PDF files will be generated with the name of each SHEET.

I would be grateful if anyone can help me out.

Regards.

Soumendu