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
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