Paste Excel Ranges into Powerpoint slides at specified slide locations

[BuJay]

I have a bunch of excel tables defined as named ranges, for Port_Table_1a, Port_Table_1b, Port_Table_1c, ...., all the way until Port_Table_22a, Port_Table_22b, and Port_Table_22c.

I also have an existing powerpoint with many slides.

How would I do the following:

1. Open the powerpoint (I can do this with below code)
2. Copy the first range (Port_Table_1a) from excel (I can do this with below code)
3. Copy slide 5 from the open PowerPoint and insert it in the next slide location, so pasted into what would now by slide 6 and the previous slide 6 would now be moved to slide 7, etc.
4. If there are any charts on the pasted slide 6, delete them
5. Paste the first named range as an HTML into the new slide 6 centered vertically and horizontally
6. Copy the second range (i.e., Port_Table_1b) from excel
7. Copy slide 11 from the open PowerPoint and insert it in the next slide location, so pasted into what would now by slide 12 and the previous slide 12 would now be moved to slide 13, etc.
8. If there are any charts on the pasted slide 12, delete them
9. Paste the second named range as an HTML into the new slide 12 centered vertically and horizontally

...then this would be repeated until all named ranges are pasted into slides


Sub Macro1()
Range("Port_Table_1a").Select
Selection.Copy
End Sub

Sub OpenExistingPPTX()

Dim ppt As PowerPoint.Application
Set ppt = New PowerPoint.Application
ppt.Visible = True

ppt.Presentations.Open ("path")

Dim ppres As PowerPoint.Presentation
Set ppres = ppt.ActivePresentation

'Count number of slides in presentation
Debug.Print ppres.Slides.Count

End Sub

 

[Domenic]

This question has also been posted here...

Paste Excel Ranges into Powerpoint slides at specified slide locations

I have a bunch of excel tables defined as named ranges, for Port_Table_1a, Port_Table_1b, Port_Table_1c, ...., all the way until Port_Table_22a, Port_Table_22b, and Port_Table_22c. I also have an

stackoverflow.com

 

[BuJay]

This question has also been posted here...

Paste Excel Ranges into Powerpoint slides at specified slide locations

I have a bunch of excel tables defined as named ranges, for Port_Table_1a, Port_Table_1b, Port_Table_1c, ...., all the way until Port_Table_22a, Port_Table_22b, and Port_Table_22c. I also have an

stackoverflow.com

yes - I posted on both locations - is that ok? Should I indicate that it is cross posted when I post?

 

[Domenic]

Yes, posting in other locations is fine. When you do so, though, you should let the members here know that you've done so. I think it's part of the rules here. Also, I think most people might not appreciate having spent time providing a solution, only to find out that you already have one.

Cheers!

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: link already provided.
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.