Convert into PDF the sheets when save and close the EXCEL file

[soumendu_bose]

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

[Kramxel]

Create a module and enter the code below, enter any sheets you wish to omit in the array vWshs = Array("Sheet1", "Sheet3", "Sheet4")

Please Login or Register  to view this content.

and in the workbook -- before close module add

Please Login or Register  to view this content.

[arronlee]

Hi, Soumendu.
I have never tried to convert the excel file into PDF. But have you ever tried the code offered by Kramxel? Did it work? How about converting PDF to other image fomats?Any suggestion will be appreciated. Thank in advance.



Best regards,
Arron