Macro Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rodney - 08 Oct 2007 11:04 GMT

Hi guys,

I think this is a rather ambitious question but im going to ask it anyway.
Basically i have a number of slides in powerpoint with various logos which
have been pasted onto a grid i have drawn. As there are many slides which
have been filled in by different people i wondered whether it would be
possible to get a macro or use al anternative method to work out the average
position of each logo from all the grids. This would then enable me to have
one frid summarising the information from lots of other grids.

Is this possible?

Many thanks,
Keith

Reply to this Message

John Wilson - 08 Oct 2007 11:22 GMT

Hi Rodney

I know YOU know what you mean but I think I'm lost!

Do you mean that the logos are different sizes/positions on different slides?
Maybe you want to produce a slide with all the logos, all the same size and
aligned nicely?

It sounds possible but you will need to be clearer as to what you need I
think.

Signature

Amazing PPT Hints, Tips and Tutorials-
http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> Hi guys,
>
[quoted text clipped - 10 lines]
> Many thanks,
> Keith

Reply to this Message

Rodney - 08 Oct 2007 11:43 GMT

Hi John,

thanks for your reply.

I mean that i have 15 slides which have exactly the same grid on them, with
a selection of different logos placed in different locations on each slide.
All slides have exactly the same logos (they are the same size), just placed
in different areas of the grid on each slide.

Essentially what i want to produce is just one 'summary' slide, which has
one copy of each logo placed on the summary grid- the location of the logos
needs to be worked out from the 15 other slides (i.e the average position of
each of the logos from the 15 slides is calculated and then each individual
logo is placed once on the 'summary' slide).

Hope that makes more sense?

Many thanks,
Rodney

> Hi Rodney
>
[quoted text clipped - 21 lines]
> > Many thanks,
> > Rodney

Reply to this Message

David M. Marcovitz - 08 Oct 2007 15:21 GMT

I belive that the hardest part of creating a macro to do this is to find
a way to identify each logo. That is, how will you know (programatically)
which logo is which? If you have an easy way to identify the logos, then
the rest shouldn't be difficult at all.
--David

Signature

David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

> Hi John,
>
[quoted text clipped - 44 lines]
>> > Many thanks,
>> > Rodney

Reply to this Message

Steve Rindsberg - 08 Oct 2007 16:15 GMT

Hi Rodney,

Let me restate this; tell me if I've got it right.

You want to look at each slide, locate the position of Logo_A, average the
positions found on each slide and use that as the position of the logo on the
summary slide. Then repeat for each add'l logo.

So for example, if you find Logo_A at

Slide 1: Top 100, Left 100
Slide 2: Top 200, Left 300

you'd want to position Logo_A on Summary Slide at Top 150, Left 200.

If that about describes it, it should be quite possible *if* there's some way of
distinguishing each logo from the other shapes on the slide.

For example, you could name or "tag" them manually.

> thanks for your reply.
>
[quoted text clipped - 41 lines]
> > > Many thanks,
> > > Rodney

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

Reply to this Message