Copying from Excel Workbook to Open Powerpoint

[spotscat]

Hello,

I am trying to achieve something very specific. I would like to write a macro that copies a range of cells in my workbook, then goes to a PowerPoint presentation that will be already open, the name of which is referenced in a cell on a different tab in the workbook, and then creates a new blank slide and pastes those cells as an enhanced metafile picture.

I cant seem to find anywhere a way to "activate" a powerpoint that already exists, the name of which is in the excel workbook.

Any help greatly appreciated.

[jolivanes]

https://www.thespreadsheetguru.com/b...point-with-vba

[spotscat]

I saw this except this creates a new powerpoint. What I am looking for for takes the range I want copied, then creates a new slide in a PowerPoint that already is in existence and is open, and pastes it.
For example:
I have a PowerPoint presentation I have been working on with many slides already.
I have an excel workbook with information that I need to tailor but once it is done I want in the above presentation on a new slide.
Every time I run the macro I want it to take that same range, create a new slide in the existing open PowerPoint presentation and paste the data

To be clear I don't want the macro to open a closed presentation, or create a new presentation I just need it to find the one I have open and am working in.