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

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
.

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
.

There are a few starter hints on this page:

http://peltiertech.com/Excel/XL_PPT.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Shilps wrote:

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
.