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.








--------------------------------------------------------------------------------
Khan