DairylandDan
Programmer
Hmm, I've got a problem that I can't seem to get around.
The company has an Excel work book with 11 Sheets. There are many functions moving and altering data entered on one sheet to other cells on other sheets. The state DNR supplies a ready built xml document and wants this data imported into the appropriate xml nodes. But, they don't have an xsd. I've tried creating an xsd from the xml document (via the following example: . . . but, the xsd which is created doesn't work when I try to do the 'export to xml' from within the excel document.
I think it has to do with the 'list of lists' problem.
I'm using Excel 2003 SP3 - Office Professional Edition 2003.
Any suggestions would be greatly appreciated.
DlD
The company has an Excel work book with 11 Sheets. There are many functions moving and altering data entered on one sheet to other cells on other sheets. The state DNR supplies a ready built xml document and wants this data imported into the appropriate xml nodes. But, they don't have an xsd. I've tried creating an xsd from the xml document (via the following example: . . . but, the xsd which is created doesn't work when I try to do the 'export to xml' from within the excel document.
I think it has to do with the 'list of lists' problem.
I'm using Excel 2003 SP3 - Office Professional Edition 2003.
Any suggestions would be greatly appreciated.
DlD