I am trying to create an Excel file that will generate the proper XML code. I am using Excel 2000, and it does not seem to like the macros that others have created in 2003 and beyond.
I am getting the following error: Parsing questions from import file.
Error importing question Invalid xml file - string expected (use CDATA?)
Here is my xml:
<?xml version="1.0" encoding="UTF-8"?>
<quiz><question type='shortanswer'> <name><text>KBr</name></text> <questiontext format 'html'><text>If potassium and bromine combine to form an ionic compound, what is the result of that reaction? To enter a subscript, use sub.<br>For example Li<sub>2</sub>O is entered Lisub2O</text></questiontext> <generalfeedback>Be sure to look up the value of each of the ion's charge and criss-cross if they do not add to zero.</generalfeedback> <defaultgrade>1</defaultgrade> <penalty>0.1</penalty> <hidden>0 </hidden> <shuffleanswers>0</shuffleanswers> <usecase>1</usecase> <answer fraction="100>" <text>KBr</text> <feedback><text>Correct, it is KBr!</text></feedback></answer> </question>
</quiz>
Any suggestions?