Copy Excel data to a large table in a ppt slide

  • Thread starter Thread starter Lily
  • Start date Start date
L

Lily

I have a large data table in power point, the content of which mainly comes
from excel spreadsheet. I cannot use copy and paste as the table doesn't
exist in excel. I want to build a vba to copy data from excel to power point
directly whenever there is an update. However, it is difficult to point to
the correct position of each data point in the power point table. Is there a
way to do this?

thanks.
 
Actually, not exactly. The problem I am facing is how to put in code each
cell in the table. The ppt file was created by someone else. And I don't know
how to refer to the table in the code. I tried recording some macros, but it
uses the group item number which I have no clue and which didn't work if I
simply copy it in VBA code.

thank you,

Lily
 
Back
Top