View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sp sp is offline
external usenet poster
 
Posts: 3
Default Automate searching and then copying files to a folder using excel

Hi

I am looking for a process that will optimize the time and effort.
I have an excel file which contains a list (1000) of file names in its
column "A".

These 1000 files are present in different folders under single folder on the
network drive.
My task is to search one by one files from the network and copy the same
into an output folder.

I understand his will take enormous time & effort to do it manually.

So, I am looking for an automation which can interface the MS excel file
with the windows searching and copying.

Appreciate your help.

Thanks

SP.