Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>To get the name of your items Run Macro settings, you'll run something like this:</p> <pre><code>Sub ActionSettingName() Dim p As Presentation Set p = ActivePresentation Dim s As Slide Dim sh As Shape Dim macroName As String For Each s In p.Slides For Each sh In s.Shapes If sh.Type = msoGroup Then Dim gs As Shape For Each gs In sh.GroupItems PrintMacroName gs Next Else PrintMacroName sh End If Next Next End Sub Sub PrintMacroName(sh As Shape) If sh.ActionSettings(ppMouseClick).Action = ppActionRunMacro Then macroName = sh.ActionSettings(ppMouseClick).Run Debug.Print macroName End If End Sub </code></pre> <p><strong>UPDATE:</strong> To get ActionSettings for TextRanges, please find below:</p> <pre><code>Sub ActionSettingName() Dim p As Presentation Set p = ActivePresentation Dim s As Slide Dim sh As Shape For Each s In p.Slides For Each sh In s.Shapes Dim tr As TextRange Set tr = sh.TextFrame.TextRange Dim macroName As String For i = 1 To tr.Runs.Count macroName = tr.Runs(i).ActionSettings(ppMouseClick).Run If Len(macroName) &gt; 0 Then Dim runText As String runText = tr.Runs(i).Text Debug.Print "RUN: " &amp; runText &amp; vbCrLf &amp; "MACRO: " &amp; macroName End If Next Next Next End Sub </code></pre> <p>Then you'll want to search for and extract that macro (and anything else you need) from the VBE inside the last For/Next loop.</p> <p>There are a <a href="https://stackoverflow.com/search?q=vbproject%20vbcomponents">few references on SO</a> on how to extract all macros in Excel/Word and work with the VBProject model - the techniques are identical to PowerPoint. See <a href="https://stackoverflow.com/questions/49724/programmatically-extract-macro-vba-code-from-word-2007-docs">Programmatically extract macro (VBA) code from Word 2007 docs</a> for one of the better examples. A much more comprehensive intro to the VBProject object model exists at <a href="http://www.cpearson.com/excel/vbe.aspx" rel="nofollow noreferrer">Programming The VBA Editor</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POExtract the VBA code associated with a macro attached to an Action button in PowerPoint
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USTodd Main
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExtract the VBA code associated with a macro attached to an Action button in PowerPoint
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COSo I guess for a "Normal" situation this would work great... I was able to use the above method to extract the macro name for the hint since it's its own separate action button. For some reason the question and answers are all in the same shape (text block)... and all the answers are also action buttons. I'm not really sure how that works having 4 action buttons that are all mouse click in the same shape. I tried querying all shapes on the slide just to make sure they weren't hiding somewhere else but I couldn't find them. Any ideas?
      singulars
      1. PO
      1. USPeter
    2. CO@Patricker: Here's what I'm thinking - those Action Buttons are grouped with a textbox. I've updated the code above that will help get the Run Macros for grouped shapes.
      singulars
      1. PO
      1. USTodd Main
    3. CO@Otaku ... doesn't look like that's it either. Here are the steps to reproduce my exact issue: 1) create a new presentation. In a text box type three lines of text. 2) Add a macro to your presentation. 3) Hilight one of the lines of text inside the text box, go to the insert tab on the ribbon, and choose Action. 4) Choose the macro option and then choose the macro from the list. 5) repeat this step for the third line (leave the second line as normal text). Now get the vba to see the action...
      singulars
      1. PO
      1. USPeter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload