Steve
Thu May 08 16:03:25 CDT 2008
In article <060A4AD7-29BB-4DFF-ADA2-B72DFB0E4392@microsoft.com>, Lily wrote:
> Actually, not exactly. The problem I am facing is how to put in code each
> cell in the table.
Not sure I follow.
You have a table in PPT. What do you want your code to do to each cell in the
table?
Oh, and have a look at these:
Working with PowerPoint tables
http://www.pptfaq.com/FAQ00790.htm
Using Excel and Access data in PowerPoint Tables (by Brian Reilly and Naresh
Nichani)
http://www.pptfaq.com/FAQ00892.htm
> 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
>
> "Steve Rindsberg" wrote:
>
> > In article <C43173FA-5A5C-4665-811D-C9579F3DA4FC@microsoft.com>, Lily wrote:
> > > 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?
> >
> > Let me re-state the problem:
> >
> > You need a way to work out, for each cell in a PPT table, which cell in an
> > Excel worksheet the data came from.
> >
> > Is that correct?
> >
> > Possibly the simplest way would be to add a new worksheet to the Excel workbook
> > and in effect duplicate the PPT table there, linking the cells to the actual
> > source in the rest of the Excel workbook.
> >
> > That way, cell 1, 1 in the PPT table could always point to cell A,1 in the
> > worksheet containing the table.
> >
> > Another approach would be tagging the table in PPT with whatever information
> > you need to find the correct cells in Excel.
> >
> >
> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> >
> >
> >
>
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================