excel generated xml doctype issues

[Shazif]

have bene trying to generate a customized xml code with excel.
I want to have output in exact format our machine responds to. Excel
generates xml but there is a problem with the top 4 lines. So I have to
manually copy those lines. The xml genearted by excel is as follows



========================================================================================

Excel generated xml



<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<SIS_EventImport_1_0 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<EventSchedule>

<Event uId="1" tBoxStart="2008.11.03-23:30:00" dBoxDur="0:30:0"
sTitle="Telebrands">

<ShortDescriptor sLang="eng" sName="Telebrands">Family
Entertainment</ShortDescriptor>

<ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>

</Event>

</EventSchedule>

</SIS_EventImport_1_0>

========================================================================================




Machine acceptable code



<?xml version="1.0" encoding="ISO-8859-15"?>

<!DOCTYPE SIS_EventImport_1_0 SYSTEM "SIS_EventImport_1_0.dtd">

<SIS_EventImport_1_0>

<?comvenient.parser CharCoding="ISO8859_15" TimeZone="LOCAL"?>


<EventSchedule sService="401" tStart="2008.10.24-0:00:00"
tEnd="2008.11.01-00:00:00">


<Event uId="1" tBoxStart="2008.10.25-00:00:00" dBoxDur="0:30:0"
sTitle="Teleshopping">

<ShortDescriptor sLang="eng" sName="Teleshopping">Family
Entertainment</ShortDescriptor>

<ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>

</Event>

</EventSchedule>

</SIS_EventImport_1_0>



========================================================================================

see the top four lines are different.

Is there a way to customize namespace and add doctype declaration at the top
via excel in the format our machine accepts it.



Please help.