ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel to powerpoint via macro (https://www.excelbanter.com/excel-programming/303829-excel-powerpoint-via-macro.html)

montoya

excel to powerpoint via macro
 
Hi!
I have an excel worksheet with a big table with
data: "data.xls"
I also have a powerpoint presentation called "present.ppt"

I want to show some of the cells of the Excel worksheet in
the Powerpoint presentation.And, I want to show this cells
in powerpoint linked to the original in excel, so the
content displayed in powerpoint is updatable only by
changing the excel.

I know how to do it manually (with copy in excel and paste
special in powerpoint as a link), but I am trying to do it
automatically with a macro and doesn't work.

Can anyone provide me a simple code to do this? (because
I'm sure that has to be simple... but I don't catch it!)
Thanks!

Jon Peltier[_7_]

excel to powerpoint via macro
 
I've posted sample code he

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

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

montoya wrote:

Hi!
I have an excel worksheet with a big table with
data: "data.xls"
I also have a powerpoint presentation called "present.ppt"

I want to show some of the cells of the Excel worksheet in
the Powerpoint presentation.And, I want to show this cells
in powerpoint linked to the original in excel, so the
content displayed in powerpoint is updatable only by
changing the excel.

I know how to do it manually (with copy in excel and paste
special in powerpoint as a link), but I am trying to do it
automatically with a macro and doesn't work.

Can anyone provide me a simple code to do this? (because
I'm sure that has to be simple... but I don't catch it!)
Thanks!




All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com