moving files (large number of)

[SteveR]

I have 60,000 data files in a folder. I have a list of
these file names and thire contents in an Excel
spredsheet. I can sort and select the file names I want
in excel.
What I do not know how to do is, how do I use
this list of file names (usually 3000-4000 file names) to
select these files and move or copy them to a different
folder.
Thanks for any help or tips,
Steve

 

[Frank Kabel]

Hi
don't use Excel for this
Excel is NOT a system management console. There're dedicated
administration programs available for such tasks

 

[SteveR]

Thanks for your reply, I origonaly posted in win98
applications and was told to post here.
Thanks
Steve.

 

[Frank Kabel]

interesting. Though in general possible to do this in Excel Excel is
just not the right tool for this (IMHO)

 

[Harlan Grove]

Thanks for your reply, I origonaly posted in win98
applications and was told to post here.

....

I just saw that posting. I suppose you could use Excel to generate a batch
file, then run the batch file. Once you have a list of the files to move in,
say, A1:A3000, insert a new worksheet and enter the following formula in its
A1 cell.

NewWorksheet!A1:
="%COMSPEC% /k ""%0"" """&OldWorksheet!A1&""""

Copy A1, use [F5] to select A2:A3000 and paste. Now insert 4 rows above row
1. Enter the following text constants (not formulas).

A1:
if .%1. == .. goto DRIVER

A2:
copy %1 "X:\Your\Destination\Folder\Here!!!!" /v

A3:
exit

A4:
RIVER

Save this new worksheet as a plain text file with its filename ending in
..bat. Find that file in Windows Explorer and run it.

This just copies the files to the new folder. You should use the fc command
to ensure that they were copied correctly. Once you've done that, change the
A2 cell above to

A2:
del %1

resave the .bat file and run it to delete the files from the original
location.