Save an Excel file into PDF with VBA

**wasim** · 24-01-2009

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** · 24-01-2009

I do this all the time using CutePDF.

Try that.

**Modifier** · 24-01-2009

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

Code:

Private Sub Workbook_BeforeClose (Cancel As Boolean)

that records in PDF, then recorded xls

**wasim** · 24-01-2009

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** · 24-01-2009

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.