Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
use a batch file
MIke wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
Bob,
I am not familar with batch files could you give me an example? Thanks, Mike "Bob I" wrote: use a batch file MIke wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
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. MIke wrote: Bob, I am not familar with batch files could you give me an example? Thanks, Mike "Bob I" wrote: use a batch file MIke wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
Thanks. It worked great.
Mike "Bob I" wrote: 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. MIke wrote: Bob, I am not familar with batch files could you give me an example? Thanks, Mike "Bob I" wrote: use a batch file MIke wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy workbook into multiple folders
You're welcome, have a great day!
MIke wrote: Thanks. It worked great. Mike "Bob I" wrote: 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. MIke wrote: Bob, I am not familar with batch files could you give me an example? Thanks, Mike "Bob I" wrote: use a batch file MIke wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to copy & paste multiple lines to another workbook? | Excel Worksheet Functions | |||
How do I send multiple workbook folders with formula links intact. | Excel Discussion (Misc queries) | |||
How do I copy print formatting to multiple sheets in a workbook? | Excel Discussion (Misc queries) | |||
opening multiple .txt files from multiple folders | Excel Discussion (Misc queries) | |||
How do I copy multiple worksheets into a new workbook? | Excel Worksheet Functions |