RE: Creating a powerpoint presentation from MS-Excel
From: Shilps (Shilps_at_discussions.microsoft.com)
Date: 07/31/04
- Previous message: Anthony: "Protecting Macros"
- In reply to: K Dales: "Creating a powerpoint presentation from MS-Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 31 Jul 2004 01:13:01 -0700
Actually, I want to create a powerpoint presenation, with all the formatting on the basis of data in Excel. I do not want to embed Excel sheet in Powerpoint. I know it has to be done through VBA but I am stuck where to start, how to do it. Could find nething in VB help also
"K Dales" wrote:
> If you just want a copy of the worksheet to be in the
> presentation (and to automatically update so any changes
> in the Excel file show in the presentation file) use (from
> Powerpoint) Insert... Object... Microsoft Excel
> Worksheet. Choose "Create from file" and specify the
> Excel file and make sure the box marked "Link" is
> checked. The link ensures that the latest copy of the
> file is loaded whenever the presentation loads.
>
> However, if you need to use individual cell values and
> insert them somewhere into the text of the presentation
> (e.g. "Our margin in April was $200,000...") this would be
> trickier and would require some pretty advanced VBA coding.
>
> >-----Original Message-----
> >Hi,
> >I have an excel sheet which keeps getting updated every
> month. I need to create a powerpoint presentation based on
> the data captured in this sheet. Is there any method of
> doing it?
> >TIA
> >Shilps
> >.
> >
>
- Previous message: Anthony: "Protecting Macros"
- In reply to: K Dales: "Creating a powerpoint presentation from MS-Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
