By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 678 - UpdateTOC - code to update ppt toc


This routine updates the Table of Contents slide



Algorithm
  • Get active PPT
  • Get All Slide Names
  • get the last row
  • Determin TOC Slide
    • for each row 1 to r
      • look for agenda in name and save as the Toc slide #

  • for each slide
    • Select the ith slide
    • For each shape on the slide
      • select it
      • if name like "content placeholder"
        • if shape is a table
          • save the r, and c row and column counts
          • get the last page
          • for each row in the table working backwards
            • Get the topic from the first cell of the table
            • Find the page of the Appendix section uses a =Match function


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit