Extract the vb code associated with a macro attached to an Action button in PowerPoint

Posted by Patricker on Stack Overflow See other posts from Stack Overflow or by Patricker
Published on 2010-05-22T14:38:30Z Indexed on 2010/05/22 14:40 UTC
Read the original article Hit count: 275

Filed under:
|
|

I have about 25 PowerPoint presentations, each with at least 45 slides. On each slide is a question with four possible answers and a help button which provides a hint relevant to the question. Each of the answers and the help button is a PowerPoint Action button that launches a macro.

I am attempting to migrate all the questions/answers/hints into a SQL Database. I've worked with Office.Interop before when working with Excel and Word and I have plenty of SQL DB experience, so I don't foresee any issues with actually extracting the text portion of the question and answer and putting it into the db. What I have no idea how to do is given an object on a slide -> get the action button info -> Get the macro name -> and finally get the macro's vb code. From there I can figure out how to parse out which is the correct answer and what the text of the hint is.

Any help/ideas would be greatly appreciated. The guy I'm doing this for said he is willing to do it by hand... but that would take a while.

© Stack Overflow or respective owner

Related posts about macros

Related posts about powerpoint