ExportAsFixedFormat Issue

[coolkiran]

Hi Again

I have a code to export active presentation to PDF in Excel macro.

Dim PPApp As Object
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide
Set PPApp = GetObject(, "Powerpoint.Application")
Set PPPres = PPApp.ActivePresentation
Dim SaveName As String
SaveName = ReportSavePath
PPPres.ExportAsFixedFormat SaveName, ppFixedFormatTypePDF, ppFixedFormatIntentPrint

When i run the code, i am getting error for ExportAsFixedFormat line
as : "Method 'ExportAsFixedFormat' of object'_Presenatation' failed.

Anyone have any suggestion

 

[Hui]

Have you had a look through: http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/
http://chandoo.org/wp/2011/08/03/create-powerpoint-presentations-using-excel-vba/

 

[coolkiran]

Thanks Hui

I have already created powerpoint from my excel data, once i created my powerpoint, i want to save that powerpoint in pdf format as well. so i used the above code. Its showing error.

Assist me.

 

[coolkiran]

Solved.

If you are using Office 2007, for above code to work you need "save as Pdf" file need to install. Download from this link : http://www.microsoft.com/downloads/...3C-6D89-4F15-991B-63B07BA5F2E5&displaylang=en.
Once installed you can run the above code. It work.

Thanks