To paste specific data in specific columns and rows to specific table in powerpoint

Hi. I'm new to vba. I'm currently having an issue where I have to update new information in specific presentation slides every month.

To be specific, I have a new data which has to be updated monthly to a specific powerpoint document. The data which is in certain column and rows (specific ranges) need to be pasted to a specific position (in this case a table) in a specific slide. May I know how? Could anyone help me?

If so, can the action be automatic? Meaning if I update my excel file, can the content in that powerpoint slide change too?

Thanks!

Hi ell and welcome to the forum,

Depending on which version of Excel and Powerpoint you have, yes you can LINK the Excel data to PowerPoint. See:

https://support.office.com/en-us/art...D-8B838CAEF853

I believe the PowerPoint will look at the current workbook and display the data that currently lives there.

I believe the feature is built into Microsoft Office, where you don't need VBA. You simply build your Powerpoint slides and include a LINK to the Excel worksheet or table or chart that you want to display. Then you go to the Excel file and update it with the latest data. When you do that slide it shows what is currently in Excel.

Here is another site to explain:

http://www.wikihow.com/Link-Excel-to-PowerPoint

My macro has to do several things:
1. Open up existing powerpoint
2. Copy multiple excel ranges (on 4 different sheets) and paste it as a linked table to different positions in different PowerPoint Slides
3. Make the data linked and can be automatically updated just like link

The problem with the coding is:
1. It is pasted as an object, not a linked table (cannot be updated via excel)
2. How to alter the position of my pasted data in the ppt slide?

Here's the code, hope anyone can help me to achieve my goals:

Please Login or Register  to view this content.

Hi ell,

Darn, I have never written VBA to or behind PowerPoint. I don't know enough about their object model to really follow your code above. Perhaps one of the other forum contributors has an answer for you. BTW - could you edit your above post by clicking on EDIT Post and then select your code and click on the "#" icon above the message area. This will put code tags around your code and follow the rules of the forum.

Sorry - I'm at a loss on this. It also sometimes gets faster replies if you can attach a sample PowerPoint with a few slides and a few Workbooks to demonstrate your problem. I'm still at a loss on exactly what you need.