Can Excel help select or open images?

[kevs]

Can excel be part of some automation.

Here is what I need:

I send an spreadsheet with 1000 image file names.

An editor send back a spreadsheet with favorite 100 (random))

So instead of me then having to go and pull, and drag each images jpeg from
hardrive one by one.
Is there any way, any software, that could "see" the 100 the editor
selected, and

1) select those files -- so I don't have to spend hours selecting them one
by one

2) or even better: select them and copy them to another folder?

Thanks!



OS 10.4.6
Office 2004

 

[Jim Gordon MVP]

Hi Kevs,

I think my PowerPoint add-in might be able to help you.
(Shameless plug here)
http://www.agentjim.com/MVP/PowerPoint/ppt2004.htm

The add-in would import one picture per slide. In slide sorter view your
editor could drag the 100 favorite pics to the slide sorter view of a
different presentation.

If you wanted those 100 as pictures then you can use PowerPoint's Save
As and choose a picture type.

-Jim

 

[kevs]

Thanks Jim:
Are you sure you understand my idea?

I send a few thousand preview images to a photo editor.

They pick a few hundred and send me an excel file with those picks.

I want (can it be done??), those picks to automatically be selected on my
hard drive ready to drag over to be copied to another hard drive or.....
Copied automatically. Is this all fantasy??

Hi Kevs,

I think my PowerPoint add-in might be able to help you.
(Shameless plug here)
http://www.agentjim.com/MVP/PowerPoint/ppt2004.htm

The add-in would import one picture per slide. In slide sorter view your
editor could drag the 100 favorite pics to the slide sorter view of a
different presentation.

If you wanted those 100 as pictures then you can use PowerPoint's Save
As and choose a picture type.

-Jim

OS 10.4.6
Office 2004

 

[Jim Gordon MVP]

Hi Kevs,

I re-read what you said, and I think it could be done.

If I understand what you are saying you would need a macro that would
manipulate the file path from one folder to another and issue copy
commands to MacOS.

That Macro could be in either Visual Basic for Applications or AppleScript.

Which of these programming languages do you feel most comfortable with?

-Jim

 

[kevs]

Neither Jim:
I would not go near either, not my cup of tea, but in short, I would then
have to hire someone to pull that off, correct? It's not something you could
find online or some software now that does it?



Kevs

Hi Kevs,

I re-read what you said, and I think it could be done.

If I understand what you are saying you would need a macro that would
manipulate the file path from one folder to another and issue copy
commands to MacOS.

That Macro could be in either Visual Basic for Applications or AppleScript.

Which of these programming languages do you feel most comfortable with?

-Jim

OS 10.4.6
Office 2004

 

[Jim Gordon MVP]

Hi Kevs,

Applescript and Visual Basic extend the capabilities of Office
applications.

It may sound scary, but don't bee too shy about tackling the task of
writing your own scripts. Granted it takes a while to get the hang of
this, but you will be rewarded with increased skills and understanding
of Office products specifically but also computing in general.

Yes, you can hire someone to write the scripts for you. That would be
the best route if you have the funds and time is essential.

Excel has a macro recorder that can record some of the actions you take.
From there you can build code. The file system commands are not
recordable, so in this particular instance the recorder will be of
limited use.

-Jim

 

[kevs]

Thanks Jim:
That's it , I would hire someone to write this for me, but it could be done?

And there is no software out there already?

If you do this, please send me your info
(e-mail address removed)

Kevs

Hi Kevs,

Applescript and Visual Basic extend the capabilities of Office
applications.

It may sound scary, but don't bee too shy about tackling the task of
writing your own scripts. Granted it takes a while to get the hang of
this, but you will be rewarded with increased skills and understanding
of Office products specifically but also computing in general.

Yes, you can hire someone to write the scripts for you. That would be
the best route if you have the funds and time is essential.

Excel has a macro recorder that can record some of the actions you take.
From there you can build code. The file system commands are not
recordable, so in this particular instance the recorder will be of
limited use.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>


kevs wrote:

OS 10.4.6
Office 2004

 

[Jim Gordon MVP]

Hi Kevs,

Yes, it is certainly do-able.

You should write it up and post the job in one of the Excel groups such
as the programming group.

-Jim