Using Excel to gather jpeg files

[evandunn]

Hi everyone,

So here's my problem. Perhaps someone can give me some ideas about the best way to deal with it.

My situation is this,

I have hundreds of excel files that contain within one column, a list of jpeg image files with the complete directory path, file name and extension. My end product needs to be a burned cd containing all the images listed. Is there some way I can automate the gathering of these images to one spot, for ease of burning?

Just as an example, in Adobe Indesign, I can load an excel file, and so long as I put " '@ " in front of the image column’s title, then Indesign will interpret the file path in such a way that it will load the image onto the screen, rather than show the file path as a text field. Then I can have Indesign export the merged document into eps, pdf or jpeg files in one place... but the problem with that process is that Indesign is unable to save the jpeg files at any sort of decent quality, and saving the images into eps or pdf formats, then exporting again, takes away any timesaving benefit.

Now, I don't necessarily need to have a way to automatically burn the images onto a cd, I just want to know if there's anything out there that can read the excel file, and then collect the images to one spot automatically, making it easier to burn them to cd.

Any ideas?

Thanks everyone!
-Evan Dunn

[mudraker]

Heres a macro that will copy the files

Change to folder as required ("c:\temp")
Change column as required ("a")

Please Login or Register  to view this content.

[shg]

Perhaps you can copy them directly to the CD drive; doesn't Windows queue them up until you tell it to write them to the CD?

[evandunn]

Perhaps you can copy them directly to the CD drive; doesn't Windows queue them up until you tell it to write them to the CD?

The trick is to save me the time it takes to hunt down the images across a long series of folders, image by image.

Heres a macro that will copy the files

I'm trying to get the macro to work. As of yet, I haven't managed to. It dosen't hit an error when I run it, but neither does it copy any files. Is perhaps my version of excel at fault? I'm running excel 2000 ( 9.0.2720 )?

Here is the modified code for my directory. For ease of use, I put the list of filepaths in the A collum, with Row 1 collum A, containing an A.

Please Login or Register  to view this content.

[mudraker]

I have added some code to test for certain conditions

Message box alert if To folder does not exist - macro then stops

Messgae into colmn B if Filecopy succusful or Failed or cannot find file to copy

Please Login or Register  to view this content.