A little help with batch file

[snjpverma]

I want to write a batch script to create folders.
I have a notepad with multiple lines in the following location C:\Users\sanjeep.verma\Desktop\Production Files\folder_list.txt
The batch file should create folders with names that is written on each line in the above text file.
In each of the newly created folder the following xlsm file must get pasted: C:\Users\sanjeep.verma\Desktop\DIW.xlsm
Please help with the batch file script as the below batch script is not working as intended.

@echo off
set folder_list=C:\Users\sanjeep.verma\Desktop\Production Files\folder_list.txt
set source_file=C:\Users\sanjeep.verma\Desktop\Debt Income Worksheet.xlsm
set target_folder=C:\Users\sanjeep.verma\Desktop\Production Files\
for /f "delims=" %%i in (%folder_list%) do (
  md "%target_folder%\%%i"
  copy "%source_file%" "%target_folder%\%%i"
)

Note: The below code works file to create the folders from each line of the text file. however, it does not paste the xlsm file into each of the newly created folders.

@echo off
for /f "delims=" %%a in (folder_list.txt) do (
    mkdir "%%a"
)

 

[jdellasala]

I'm surprised it works at all. Quotes are needed in your SET commands for any file/folder with spaces in the name.

@echo off
set folder_list="C:\Users\sanjeep.verma\Desktop\Production Files\folder_list.txt"
set source_file="C:\Users\sanjeep.verma\Desktop\Debt Income Worksheet.xlsm"
set target_folder="C:\Users\sanjeep.verma\Desktop\Production Files\"
for /f "delims=" %%i in (%folder_list%) do (
  md "%target_folder%\%%i"
  copy "%source_file%" "%target_folder%\%%i"
)

 

[snjpverma]

@jdellasala , thanks for your response.

I think the problem was with some access issues due to which the batch file wasn't working. So, I copied the source file in the same directory as the target folder and it worked. I guess, since everything is in the same folder, the batch file works without the quotes.

However, I need one help with the below code (latest version that works). The source file that gets copied into each folder should be renamed with the same name as the directories they are pasted in.

Example: if the directory created is named "John - 567", then the Debt Income Worksheet.xlsm should get pasted inside it and then renamed as "John - 567" i.e. same as the directory name.

@echo off
set folder_list=folder_list.txt
set source_file=Debt Income Worksheet.xlsm
set target_folder=C:\Users\sanjeep.verma\Desktop\Production Files\
for /f "delims=" %%i in (%folder_list%) do (
  md "%target_folder%\%%i"
  copy "%source_file%" "%target_folder%\%%i"
)

I tried adding this line of code at the end but it doesn't work.

ren "%target_folder%%%i%source_file%" "%%i.xlsm"

 

[veyselemre]

try this..

  copy "%source_file%" "%target_folder%\%%i\%%i.xlsm"

 

[snjpverma]

try this..

  copy "%source_file%" "%target_folder%\%%i\%%i.xlsm"

Should I add this in the end of the code in post # 3 ?

 

[veyselemre]

Change it.
FROM

  copy "%source_file%" "%target_folder%\%%i"

TO

  copy "%source_file%" "%target_folder%\%%i\%%i.xlsm"

 

[snjpverma]

Thank you so much @veyselemre . The change you suggested works perfectly fine.

 

[snjpverma]

@echo off
set folder_list=folder_list.txt
set source_file=Debt Income Worksheet.xlsm
set target_folder=C:\Users\sanjeep.verma\Desktop\Production Files\
for /f "delims=" %%i in (%folder_list%) do (
  md "%target_folder%\%%i"
  copy "%source_file%" "%target_folder%\%%i\%%i.xlsm"
)

@veyselemre the above code is the one that I am using now. It is working perfectly but the problem is that if the folders already exists. It overwrites the files inside it. I do not want any overwriting of the files. ​

If the folders/directories of the same name already exist, then the code should just not proceed. ​

 

[veyselemre]

Hi, try this.

@echo off
set folder_list=folder_list.txt
set source_file=Debt Income Worksheet.xlsm
set target_folder=C:\Users\sanjeep.verma\Desktop\Production Files\
for /f "delims=" %%i in (%folder_list%) do (
  if not exist "%target_folder%\%%i\" md "%target_folder%\%%i"
  if not exist "%target_folder%\%%i\%%i.xlsm" copy "%source_file%" "%target_folder%\%%i\%%i.xlsm"
)

 

[snjpverma]

Thank you once again. It works exactly as required.