Hi,

I hope you are well and safe.
I want to create a powerpoint summary based on text color (255,0,0), the VBA code will loop through all the slides and search text (including tables, shapes etc) and export it in Excel.

Here an idea of Excel's report :
| Slide # | Found text in RED | Hyperlink |

I googled my queries and found some useful codes:

Please Login or Register  to view this content.
Based on that code I adapt it to my query :

Please Login or Register  to view this content.
But here are the points:
  • The code does not extract all the text in red; and I dont understand why
  • When I do a array to export slide number and hyperlink, this is not "working" maybe .csv file is not appropriate?


If anybody could help me with that, this will be great!