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.

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 Wizard
http://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.

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.

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 Wizard
http://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.

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.

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

Have a look he

http://skp.mvps.org/vb/pptvbwnd.htm

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================