PowerPoint linked to Excel

[Mike]

I belong to a photo club and we use PP to display photos on one computer and
use another computer to record the score for each image. Can this be done on
one computer by linking PP & Excel?

 

[Brian Reilly, MVP]

The answer is Yes. Directions on how to do this and to get it
refreshed depend on a variety of issues, e.g. what version of Office,
will Excel be open at same time, is this to automatically update, etc.

Brian Reilly, MVP

 

[Mike]

I am using MS Office 2007. Yes Excel and PP will both be open. The images
will be in PP and each with it's own name, in Excel there will be 5 columns
(firstname, lastname, imagename, class and score. Once a image is projected
from PP and the judges give it a score, the score keeper records that score
and then advances to the next image. After all the images are judged and
scored, they are sorted in excel. 50% then will get awards. Those 50% then
will be projected from the lowest score to the highest. It would be nice to
include the image name, the maker's name and the score with the image.

That is what I would like to do, but don't have the slightest idea how to do
it.

 

[Brian Reilly, MVP]

Mike,

I was waiting for Steve to show up. I wasn't quite sure what you were
doing logistically and it sounds like you don't have much experience
in VBA coding where this could be done easily in a variety of ways.

Comment back with more logistics and probably take a look at the Merge
tool in PPTools as Steve suggests.

Brian Reilly, MVP

 

[Mike]

Steve,

The advantage is less mistakes and less time! Presently we do use 2 laptops
just as you suggest. But the problem is after the judging. 50% of the
entry's are accepted, from that group we pick the top 3 for 1st, 2nd and 3rd
place. Here is the problem, now we have to find those images in PP and
arrange them by there score. The Excel file would be sorted, but we can't do
the same with the images in PP. This process has to be done 4 times because
we have images in 4 different catalogers, and it's a big pain.

Do you think your pptools, Merge program would work for us?

 

[Mike]

I will look in to pptools, merge, but I also wonder what can be done with VBA
coding. I have no experience in VBA coding but could learn given some time.
How do I get VBA software, and just how easy can the coding be done.

In the message to Steve I tried to give more detail in what process we are
doing now manually.

One thing I would like to mention; In Feb 2008 I will be hosting a
International photo competition which will involve hundreds of images from
around the world, http://greatlakesdigitalsalon.org and need a solution
before the judging.

Mike