Copying Excel range to existing PowerPoint file

[benishiryo]

hi guys. previously, LJMetzger helped me with this post
http://www.excelforum.com/excel-prog...via-excel.html

basically, it opens a powerpoint file in my computer and transfer data from Excel to PowerPoint. i now need to transfer a range of cells to PowerPoint in a table format. i found this link but it opens a new powerpoint file instead of an existing file.
https://www.thespreadsheetguru.com/b...point-with-vba

i tried to use this set of code:

Please Login or Register  to view this content.

changed it slightly to:

Please Login or Register  to view this content.

didn't work though. any ideas?

[karedog]

Hi benishiryo,

I think this object should be adjusted as well :

Please Login or Register  to view this content.

[benishiryo]

thanks, karedog. that seems to have done the trick!

[karedog]

You are welcome, glad I can help.


Regards