title: List of workbook VBA functions?
body: <p>I have managed to get a list of the sheets and macros of a workbook using VBA Extensibility:</p>
  
  <pre><code> For Each oComp In ThisWorkbook.VBProject.VBComponents
        Debug.Print oComp.Name
      Next oComp
  </code></pre>
  
  <p>Is there a way to get a list of the functions declared within the module and even better, a list of functions referred to within the code/the code itself?</p>
  
  <p>Eventually this is to open other workbooks and list their functions/dependent functions.</p>