Excel XML question

[alwayshouston]

Hi All
I could not find much information on the web in terms of Excel generating XML and schema from a workbook. I know that Excel 2003 does create a XML and schema for any given workbook/worksheets, but my question is that how can you create XML that you define? How can you create your own custom schema in Excel? Can you accomplish what I have mentioned earlier? Feel free to direct me to any web page for detail information on XML and Schemas in Excel.

Thanks in Advance!

 

[brownmary]

alwayshouston,

Did you figure out how to use your own schema in Excel? I'm trying to do the same thing.

Thks,

brownmary

 

[alwayshouston]

No, I could not find any information on it. I end up using XML Spy to create my schema. You can also use .NET applications such as VB.net to create schemas.

 

[brownmary]

Thank you for your help.

Mary