Hi all, I need a little help on some automation work Im currently looking at. The work at a high level is:
Data table in Excel is moved row by row into a table on a PowerPoint slide. All the code to open PPT move data format etc is in place but I am struggling with one element:
When pasting in the data from the table (content will change weekly) in excel there are more rows in the table on PPT slide than what fits the height of the slide.
Q: How do I manage this and in the event the table runs over it duplicates or copies the slide, clears the table on say slide 2, leaving headers, then continue from where slide 1 left off adding in the rows?
I can only find very little on the web regarding this but the issue is that the table will likely span 15 slides in totality so automation is def the way to go.
Your help, as always, is hugely appreciated
Im using windows 7, office 2013
Data table in Excel is moved row by row into a table on a PowerPoint slide. All the code to open PPT move data format etc is in place but I am struggling with one element:
When pasting in the data from the table (content will change weekly) in excel there are more rows in the table on PPT slide than what fits the height of the slide.
Q: How do I manage this and in the event the table runs over it duplicates or copies the slide, clears the table on say slide 2, leaving headers, then continue from where slide 1 left off adding in the rows?
I can only find very little on the web regarding this but the issue is that the table will likely span 15 slides in totality so automation is def the way to go.
Your help, as always, is hugely appreciated
Im using windows 7, office 2013
