copy workbook into multiple folders

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to copy a workbook into multiple folders without doing it one
at a time? I need to copy one workbook and place it into 50 folders.

Thanks in advance,
Mike
 
make a txt file named something like COPY50.txt with contents with below
as example but use the correct paths.

Xcopy c:\original-directory\file.xls C:\other-directory1\file.xls
Xcopy c:\original-directory\file.xls C:\other-directory2\file.xls
Xcopy c:\original-directory\file.xls C:\other-directory3\file.xls

and so on.


Then when you have it all made and saved change the file name to
COPY50.bat, then you may double-click to run it and make your 50 copies
in the correct folders.
 
Thanks. It worked great.

Mike

Bob I said:
make a txt file named something like COPY50.txt with contents with below
as example but use the correct paths.

Xcopy c:\original-directory\file.xls C:\other-directory1\file.xls
Xcopy c:\original-directory\file.xls C:\other-directory2\file.xls
Xcopy c:\original-directory\file.xls C:\other-directory3\file.xls

and so on.


Then when you have it all made and saved change the file name to
COPY50.bat, then you may double-click to run it and make your 50 copies
in the correct folders.
Click to expand...
 
Back
Top