I am having a bear of a time getting a batch file to delete the first two lines of every file and replace them with a file of the same name and “<scenarioFile>”

So changing

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<scenarioFile xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<updateRec>
<ec>CME</ec>

To

<scenarioFile>
<updateRec>
<ec>CME</ec>



Since it is a batch file, you can show me how to do this to one file, and then I can copy paste the rest into the batch (I hope that makes sense)

The unwanted schema was added by Excel.

Thank you for your help.

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1 > nul
del %temp%\newfile.tmp

now you can run this from the command prompt:
for %a in (*.ext) do changelines %a

replace *.ext with the wildcard of your excel files

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1
del %temp%\newfile.tmp

now from the command line, do this:
for %a in (*.ext) do changelines %a

replace *.ext with the filename and type of your excel files.

make a batch file called changelines.cmd
@echo off
echo.
for /f "tokens=1* delims= " %%a in (%1) do (
if %%a==^<?xml echo. 2>%temp%\newfile.tmp
if %%a==^<scenarioFile echo ^<scenarioFile^> >>%temp%\newfile.tmp
if not %%a==^<?xml if not %%a==^<scenarioFile echo %%a%%b >>%temp%\newfile.tmp
)
copy /y %temp%\newfile.tmp %1
del %temp%\newfile.tmp

now from the command line, do this:
for %a in (*.ext) do changelines %a

replace *.ext with the filename and type of your excel files.