VBA & Macro Problems

How to Export PowerPoint Comments to Excel Using VBA

Phi Hung Vo Oct 10, 2026 869 views

Question details

The user requires a VBA macro to extract comments, replies, comment statuses, referenced slide text, reviewer names, dates, and slide numbers from a PowerPoint presentation into an Excel worksheet.

How to Export PowerPoint Comments to Excel Using VBA

Product: PowerPoint, Excel
Device & OS: not provided
Scenario: Aggregating presentation feedback by automatically pulling all review comments and metadata into a structured Excel spreadsheet for easier tracking and reporting.
Observed behavior: Because native tools lack a direct 'Export Comments to Excel' feature that includes full threaded replies and statuses, a custom VBA script is required.

Before you start

Before attempting to write or run macros, ensure that the Developer tab is enabled in both PowerPoint and Excel so you can access the Visual Basic for Applications (VBA) editor.

Solution 1Recommended

Seek Custom VBA Solutions on Stack Overflow

Since extracting threaded comments and replies requires a highly customized script, Microsoft officially recommends using Stack Overflow to get tailored VBA programming assistance.

Exporting modern threaded comments, status markers, and slide content involves advanced manipulation of the Office Object Model. Because there is no single generic script that fits all presentation structures, consulting a dedicated programming community is the most effective approach.

Prepare your existing code and requirements

Gather any VBA code you have already tried, even if it is incomplete. Clearly list out all the data points you need exported (e.g., slide numbers, reviewer names, comment text, replies, and statuses).

Visit Stack Overflow

Go to the Stack Overflow website and log into your account, or create a new one if you do not have one.

Post your question with proper tags

Ask a new question detailing your requirements. Be sure to include a sample of your desired Excel output format. Apply the 'vba', 'powerpoint', and 'excel' tags to ensure your question reaches experienced Office developers.

Seek Custom VBA Solutions on Stack Overflow

Official Recommendation: Microsoft actively monitors and recommends Stack Overflow for Office VBA programming queries. Providing clear examples of your expected output greatly increases your chances of getting a working script.

Solution 2

Review Basic VBA Object Models for Comments

Familiarize yourself with the PowerPoint VBA objects needed to extract comments before posting your query or writing your script.

Free Microsoft Office alternative

Try WPS Office for Seamless Presentation Reviews

While custom VBA scripts can be complicated to maintain in Microsoft Office, WPS Office provides a lightweight, highly compatible alternative for everyday presentation tasks. WPS Presentation supports intuitive comment threading, making it easier to review and manage presentation feedback without writing code.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open your presentation: Launch WPS Presentation and open your existing .pptx file containing the feedback.
3. Manage comments visually: Navigate to the Review tab to intuitively read, reply to, and track presentation comments without needing complex VBA scripts.

Fully compatible with Microsoft PowerPoint (.pptx) formats, preserving all your slides, formatting, and comments.Free and lightweight alternative to Microsoft Office, ensuring fast performance on any device.Familiar, tabbed user interface allows for a seamless migration with zero learning curve.Built-in robust review tools for reading, replying to, and resolving presentation comments effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Can I export PowerPoint comments to Excel without using VBA?

Currently, Microsoft PowerPoint does not feature a built-in, one-click button to export comments directly to Excel. You must rely on custom VBA scripts, third-party add-ins, or manually copy-pasting the feedback.

Why aren't my comment replies showing up in my older VBA script?

Older versions of PowerPoint used basic comment objects. Modern versions use threaded comments, meaning replies are treated as sub-objects. Your VBA script needs to specifically iterate through the 'Replies' collection within each main 'Comment' object.

Where can I find official documentation for PowerPoint VBA?

You can find comprehensive reference materials, object models, and syntax guides on the Microsoft Learn website under the Office VBA reference section. Alternatively, pressing F1 in the VBA Editor will often bring up contextual help.

Excel & Data Problems