Passing reports to PowerPoint?
 

There is a fellow at work that would like to send a formatted worksheet
range to PowerPoint. Maybe eight ranges/slides in all. They would like to
automate the process. We are using Office XP. How would this be done?

Don <www.donwiss.com (e-mail link at home page bottom).

Passing reports to PowerPoint?
 

Don,

If the range is always the same - i.e. no change in range dimensions - then
simply paste link them in powerpoint. Copy each range in Excel, switch to
powerpoint and select Paste Special, Paste Link.

Robin Hammond
www.enhanceddatasystems.com

"Don Wiss" wrote in message
...
There is a fellow at work that would like to send a formatted worksheet
range to PowerPoint. Maybe eight ranges/slides in all. They would like to
automate the process. We are using Office XP. How would this be done?

Don <www.donwiss.com (e-mail link at home page bottom).

Passing reports to PowerPoint?
 

Jon Peltier has sample code for sending data to PowerPoint:

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

Don Wiss wrote:
There is a fellow at work that would like to send a formatted worksheet
range to PowerPoint. Maybe eight ranges/slides in all. They would like to
automate the process. We are using Office XP. How would this be done?

Don <www.donwiss.com (e-mail link at home page bottom).


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Passing reports to PowerPoint?
 

On Tue, 12 Apr 2005, Debra Dalgleish wrote:

Don Wiss wrote:
There is a fellow at work that would like to send a formatted worksheet
range to PowerPoint. Maybe eight ranges/slides in all. They would like to
automate the process. We are using Office XP. How would this be done?

Jon Peltier has sample code for sending data to PowerPoint:

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

Thanks. It does show what is involved. But very chart oriented, and no
charts here. The relationship people want to be able to e-mail supporting
calculations. Maybe outputting these print ranges into PDF files would make
more sense.

Don <www.donwiss.com (e-mail link at home page bottom).

Passing reports to PowerPoint?
 

One of the sections on that page that looked relevant was:

Paste a Selected Excel Worksheet Range into the Active PowerPoint Slide
http://peltiertech.com/Excel/XL_PPT.html#rangeppt


Don Wiss wrote:
On Tue, 12 Apr 2005, Debra Dalgleish wrote:


Don Wiss wrote:

There is a fellow at work that would like to send a formatted worksheet
range to PowerPoint. Maybe eight ranges/slides in all. They would like to
automate the process. We are using Office XP. How would this be done?


Jon Peltier has sample code for sending data to PowerPoint:

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


Thanks. It does show what is involved. But very chart oriented, and no
charts here. The relationship people want to be able to e-mail supporting
calculations. Maybe outputting these print ranges into PDF files would make
more sense.

Don <www.donwiss.com (e-mail link at home page bottom).


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html