Convert Multiple Powerpoint Files into PDF with Excel VBA

Best Online Course : SAS Programming with 50+ Case Studies

- Explain Programming Concepts in Simple English
- Live Projects & Case Studies
- Job Placement Assistance
- Get 10% off till Sep 11, 2017
- Batch starts from October 8, 2017

The following programs allow you to batch convert Microsoft PowerPoint 2000, 2003, 2007 presentations into PDF file format.

Prerequisites:
MS Office Add-in: Save as PDF or XPS

This add-in is pre-installed in Office 2010 package. If this add-in is not installed on your computer, download it from the Microsoft site : Download Add-In

(If this link is not working, Google search on "Save as PDF or XPS MS Office" and you'll find the link working)

1. Convert the whole powerpoint file into PDF

The following program creates a PDF file of the whole powerpoint presentation from files in a folder.The PDF files are saved in the same directory where PPT files are stored.

Enter the folder path in cell C3 as shown below :

How to use

Download the workbook  and enter the folder path in cell C3.
And then hit PDF Conversion button.

OR

1. Open Excel . Press Alt + F11 to open the visual basic editor.
2. Go to Tools >> References and check Microsoft Powerpoint Object library
3. Go to Insert >> Module to insert a new module.
4. Paste the above program into the module.
5. Mention the folder path in cell C3.
6. Press Alt + F8 , select "Converter" macro and hit Run button.

2. Convert the specified powerpoint slide into PDF

The following program creates a PDF file of the specified powerpoint slide from presentations in a folder. It displays a prompt in a dialog box to enter the slide number.
How to use

Download the workbook  and enter the folder path in cell C3.
And then hit PDF Conversion button. After that it will prompt you to enter a slide number. 

OR

1. Open Excel . Press Alt + F11 to open the visual basic editor.
2. Go to Tools >> References and check Microsoft Powerpoint Object library
3. Go to Insert >> Module to insert a new module.
4. Paste the above program into the module.
5. Mention the folder path in cell C3.
6. Press Alt + F8 , select "Converter" macro and hit Run button.

3. Convert each slide as a seperate PDF file

The following program creates a PDF file of each slide from the presentations in a folder.

How to use

Download the workbook  and enter the folder path in cell C3.
And then hit PDF Conversion button.

OR

1. Open Excel . Press Alt + F11 to open the visual basic editor.
2. Go to Tools >> References and check Microsoft Powerpoint Object library
3. Go to Insert >> Module to insert a new module.
4. Paste the above program into the module.
5. Mention the folder path in cell C3.
6. Press Alt + F8 , select "Converter" macro and hit Run button.

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

5 Responses to "Convert Multiple Powerpoint Files into PDF with Excel VBA"

  1. Great article. thanks it was very helpful.

    ReplyDelete
  2. I really like the third strategy, but for some reason, the macro is only extracting and saving slides as PDF's for files that were modified with today's date. I've tested this multiple times - the macro opens all decks in my file path, but only converts the files that were modified today. Any suggestions on how to fix this?

    ReplyDelete
  3. Try the best excel macroto pdf filename online directly and easily with high quality on tagpdf.com page http://www.tagpdf.com/online/convert-excel-to-pdf/.

    ReplyDelete
  4. Thanks a ton..

    ReplyDelete
  5. useful article, thank you!

    ReplyDelete

Next → ← Prev