Need Utility (Or A Script)

[Dinsdale]

I have a list of file names in an Excel spreadsheet, listed in a column.

I need to use this list to find files in various folders on a server, and copy these files to a new folder so I can burn a CD-R.

This could be done manually, of course, but I have nearly 1,000 file names to locate, and copy to one central location for the CD-R.

Any suggestions?

A shareware utility? Or a script of some sort? How can I do this?

It can't be THAT hard!

Thanks.

 

[CTho9305]

export it to CSV, but use tabs instead of commas.
in a command prompt:
cd the_new_folder
type thecsvfile.csv | xargs copy

You'll need cygwin xargs. You can get all of cygwin from the official site, or you can get the files you need for xargs from me:
xargs.exe
cygwin1.dll
cygintl-1.dll

Just dump them in the directory you're going to run from. I, obviously, cannot guarantee anything about those files.

 

[CTho9305]

Hmm, that doesn't work the way I'd hoped. On unix, doing a "cat foo.txt |xargs blah", for foo.txt looking like

asdf
fdsa
abcd
dcba

would run:
blah asdf
blah fdsa
blah abcd
blah dcba

I wonder if it's a cygwin newline issue, or I'm doing something wrong.

 

[kosstamogen]

you could write a macro in excel with VBA. You can read the cells, then jump to the directory, and I believe u should be able to copy those files also. Before I used it I didn't know how powerful the vb interface was in excel. it can do a lot...

 

[kosstamogen]

I wonder if quick reply subscribes.