Connect PowerPoint and Excel

How to connect PowerPoint and Excel so that each slide in the PowerPoint slideshow displays the next Excel cell in the cell in column A of Excel?

+3
source share
1 answer

Well, this is a bit of programming, but basically you want:

  • Set Excel link in PowerPoint VBE.
  • See where in PowerPoint you want the text of the Excel cell to appear as a placeholder for the header.
  • Create an event SlideChangein the class and use the slide to change, read the index of the slide and match it with the next cell from an array of cells.
  • Put this displayed index text in yours when the slide changes.
  • , - , F5 Auto_Open.

, , .

0

Source: https://habr.com/ru/post/1741369/