| 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 | |||
Hybrid Mode
