View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.powerpoint
[email protected] JohnRCampbell@gmail.com is offline
external usenet poster
 
Posts: 6
Default PowerPoint Chart Preview in VBA Userform

Thanks, except I am displaying the image in a VBA UserForm, not on a
slide.

On Mar 28, 10:39*am, "Shyam Pillai" wrote:
John,
This might interest you
Create a presentation of slide images (w/o using API *or exporting &
re-inserting images)http://skp.mvps.org/pptxp003.htm

Regards,
Shyam Pillai

Handout Wizardhttp://skp.mvps.org/how

wrote in message

...

I am using PPT2003.


I think my terminology may have thrown things off. I want to preview
the entire slide, not just a chart/graph.


I kind of worked up a hack that is working, but it not very optimal. I
create a powerpoint object, new presentation, build a slide, export it
as a picture file, then link a picture viewer on the form to the
export, then kill the powerpoint object. I'd like to avoid writing a
file to the hard drive though.


On Mar 28, 8:15 am, "Shyam Pillai" wrote:
If you are using PPT 2003 or earlier look up the MS graph object and
automating it in context of PowerPoint. You will find plenty of examples
on
MSDN. If it is PPT 2007 then native charts are broken in the object
model.


Regards,
Shyam Pillai


Handout Wizardhttp://skp.mvps.org/how


wrote in message


....


Hello everyone,


I am attempting to add functionality to an Excel VBA macro that will
allow a user to build a Powerpoint chart using various named ranges
and such in Excel. I thought it would be good to have a "preview" of
what the final product would look like in the user form that acts as
the user's interface. There doesn't seem to be a lot of information on
this (or at least I cannot find it). Is this possible without using
API calls?


I was thinking along the lines of programatically creating a
powerpoint application object, adding a new chart, etc, and somehow
embedding a "view" from powerpoint into the user form. There doesn't
seem to be anything related to PowerPoint in the "Additional
Controls..." dialog so I am at a loss.