Save an Excel file into PDF with VBA

[wasim]

Hello,

At the closure of an Excel file, it can record in xls and pdf?

Is there a VBA code for this?

Thank you

[Derwin]

I do this all the time using CutePDF.

Try that.

[Modifier]

Originally Posted by wasim

At the closure of an Excel file, it can record in xls and pdf?

aftab1

But you can do a code on the VBA macro

Private Sub Workbook_BeforeClose (Cancel As Boolean)

that records in PDF, then recorded xls

[wasim]

Hello,

But we must go through mandatory Acrobat? In an Excel spreadsheet when I click "Save as," I do not know what format I have to apply in my Macro, the PDF format does not exist.
Thank you

[aftab1]

Hi, if you have Excel 2007 with the inclusion of additional downloadable
http://www.microsoft.com/downloads/d...displaylang=en
And you can also use PDFCreator.