I'd like to show all the available charts in a powerpoint
slide in a useform so that the user can select which one
to put data in.

My original thought is that it would be easy, using the
export method on these shapes to convert them to images
which I refer to in the userform.

Unfortunately, although you can do this for excel charts,
charts (which are referred to as shapes) in powerpoint
don't offer this method.

They do offer the copy method but I can't work out how I
could use this efffectively to do what I want.

Any ideas?

Mat

This sounds like you are asking how to get a static image of the chart (on a
one time basis). If so
Paste them (the copy of the charts) into an paint type program and save them
as a jpg or gif.

--
Regards,
Tom Ogilvy


"Mat" wrote in message
...
I'd like to show all the available charts in a powerpoint
slide in a useform so that the user can select which one
to put data in.

My original thought is that it would be easy, using the
export method on these shapes to convert them to images
which I refer to in the userform.

Unfortunately, although you can do this for excel charts,
charts (which are referred to as shapes) in powerpoint
don't offer this method.

They do offer the copy method but I can't work out how I
could use this efffectively to do what I want.

Any ideas?

Mat

It sounds like you've misunderstood or I haven't clarified sufficiently
what I'm looking for. This isn't a one off task.

What I need is to run a routine which will create a picture for each
powerpoint chart (referred to as shapes in powerpoint) in a user
selected powerpoint slide.

I have however come up with a solution (curtesy of the inspiring
solutions on Andy Pope's website) which is simply to paste the shapes
into an empty excel chart and export that chart as a gif.

With a little repositioning and resizing (which I probably would have to
do anyway) it works a treat.

Thanks all the same

Mat N

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!