Others

How to Export PowerPoint Slides as Numbered PNG Files with VBA

Khadija Khan Oct 21, 2026 868 views

Question details

The user needs a reliable VBA macro to export every slide in a PowerPoint presentation as individual, sequentially numbered PNG files using the presentation's filename as a prefix.

Exporting PowerPoint Slides as Numbered PNG Files Using VBA

Product: PowerPoint
Device & OS: not provided
Scenario: Automating the bulk export of presentation slides to images without creating unwanted subfolders or risking filename conflicts.
Observed behavior: Existing scripts often contain object type errors, fail if the file is unsaved, and abruptly close the entire application, risking data loss in other open presentations.

Before you start

Ensure your presentation is fully saved to a local directory before running the macro, as the script relies on the file's saved path to determine the export location.

Solution 1Recommended

Implement a Corrected VBA Macro

Use a robust VBA script that explicitly defines variables, checks if the file is saved, and loops through slides to export them as PNGs safely.

Many auto-generated VBA scripts contain foundational errors such as incorrect object types (Application, Presentation, Slide), failure to check the presentation's save status, or dangerous commands like 'Application.Quit' which close all active presentations.

To resolve these issues, you must declare object variables accurately and use the ActivePresentation.Path property to construct a valid file path dynamically.

Open the VBA Editor

Press ALT + F11 while in your presentation to open the Visual Basic for Applications (VBA) editor.

Insert a New Module

Go to Insert > Module from the top menu to create a blank workspace for your script.

Add and Validate the Code

Paste your VBA script. Ensure it contains logic to check 'If ActivePresentation.Path = "" Then', warning you if the file is unsaved. Verify that variables like 'sld As Slide' are explicitly typed and the 'sld.Export' function handles the path construction properly.

Remove Application Closure Commands

Review the bottom of the script and delete commands like 'Application.Quit' or 'ActivePresentation.Close' so the macro does not unexpectedly close other open work.

Run the Macro

Press F5 or click the Run button to execute the code. Check the directory where your presentation is saved for the sequentially numbered PNG files.

Test on a Copy: Always test new VBA macros on a backup copy of your presentation to prevent accidental data loss or unexpected file modifications.

Effortless Slide Exporting

Export Slides to Pictures Natively in WPS Office

You do not need complex VBA scripts to export slides to images. WPS Presentation includes a built-in feature to export all slides as high-quality PNGs instantly, perfectly preserving formatting and automatically numbering the files.

1. Open your presentation: Launch WPS Presentation and open your .pptx or .ppt file.
2. Access the Export tool: Navigate to the 'Tools' tab on the top ribbon and click on the 'Export to Picture' button.
3. Configure export settings: Choose 'Export Every Slide', select 'PNG' as the output format, and specify your desired output folder.
4. Complete the export: Click 'Export' to automatically generate numbered image files for all your slides without needing a single line of VBA code.

Built-in Export to Picture tool requires no coding or macrosPerfect compatibility with Microsoft PowerPoint (.pptx) formatsSupports exporting as PNG, JPEG, BMP, or TIFAdjustable image quality and custom watermark options

microsoft office alternative - wps office

Frequently Asked Questions

Why does my VBA script throw a runtime error when exporting slides?

This usually happens if the presentation hasn't been saved yet. The VBA script looks for the ActivePresentation.Path to know where to save the PNGs. If the path is empty, the code fails. Always save your file before running an export macro.

How do I change the resolution of exported PNG slides using VBA?

While the standard Slide.Export method uses the default system resolution, you can force higher resolutions by either modifying the Windows Registry's ExportBitmapResolution setting or specifying the ScaleWidth and ScaleHeight parameters directly in your VBA export command.

Does WPS Presentation support Microsoft PowerPoint VBA macros?

WPS Office supports VBA, allowing you to run many standard PowerPoint macros. Ensure you have the VBA module installed in your WPS Office version, then press ALT + F11 to access the editor.

How can I prevent the macro from overwriting existing PNG files?

You can enhance your VBA script with a Dir() check to see if a file name already exists before exporting. Alternatively, append a timestamp variable (like Format(Now(), "yyyymmdd_hhmmss")) to the output file name string.

Office Quick Solutions