Batch Files and excel document

[help_questions]

Here is a rundown of what I want to do....
1) In excel files names Files.xls (stored in C, I will have a list of mp3 format files going down column A. It could be one, two, ten however many files. I will input my mp3 file names manually in excel, close and save the xls document.

2)Then I need a batch file that will look into column A of the above excel document, find the mp3 files, copy them and paste them.
I will want to input the path(either in excel file before save and close, or (preferably, via input box) to be searched.
I want the files copied to C:\Files

I am stuck with this one.

 

[Scott820]

Im not 100% on what your after...

i use excel to 'build' the batch file. which involves getting all your required input information in the right format, and things like where its going etc etc.

then, simply concatenate it all up into a huge line (eg copy "c:/mp3/prince.mp3" "c:/files/"), then copy and paste it out into notepad, and save as a batch file, and run...

I did a similar thing to rename 1400 megadrive roms that were stored in 8.3 format! I wrote a small prog to drop out the characters specifically within the file needed, dropped it into excel with the file names, and made a huge batch file to rename them all in one go...

Took a few hours, but worth it in the end :D

 

[help_questions]

can you email me your long batch file....
help_questions@hotmail.com