Pomoc s makrem v Excelu

[dhous]

Dobry den,
potreboval bych poradit. Mam tabulku v Excelu (viz priloha) a potrebuji ji dostat do nasledujiciho formatu:

Multiple choice (jen jedna otazka spravne) vypada nasledovne:

<item>
<type>mc</type>
<question id="2" shuffle="y" scorelevel="0" points="1" feedback="n" feedbackok="Correct !" actionok="0" feedbackwrong="Incorrect !" actionwrong="0" attempts="9999" audio="n" time_limited="n" hh="0" mm="0" ss="5" time_limited_show="n" expanded="1">Who won the World Cup in 1970</question>
<scenario scinclude="0"></scenario>
<answer correct="y" id="1" feedback="" points="10" action="0">Brazil</answer>
<answer id="2" feedback="" points="10" action="0">England</answer>
<answer id="3" feedback="" points="10" action="0">West Germany</answer>
<answer id="4" feedback="" points="10" action="0">Italy</answer>
</item>

Multiple response (vice odpovedi spravne) vypada nasledovne:

<item>
<type>mr</type>
<question id="6" shuffle="y" scorelevel="0" points="1" feedback="n" feedbackok="Correct !" actionok="0" feedbackwrong="Incorrect !" actionwrong="0" attempts="9999" audio="n" time_limited="n" hh="0" mm="0" ss="5" time_limited_show="n" expanded="1">Which of these teams have won the World Cup more than twice</question>
<scenario scinclude="0"></scenario>
<answer id="1" feedback="" points="10" action="0">France</answer>
<answer correct="y" id="2" feedback="" points="10" action="0">Brazil</answer>
<answer correct="y" id="3" feedback="" points="10" action="0">Italy</answer>
<answer id="4" feedback="" points="10" action="0">Spain</answer>
</item>

kde kazda otazka bude pretvorena do podoby viz vyse. Hodnota <type>mc</type> se lisi podle toho zda se jedna o mutiple choice (mc) nebo multiple response (mr). question id="2" kde cislo se meni podle cisla otazky, pripadne jak si primo urcit pocatecni cislo od ktereho udelat inkrement +1 pro databazi (abych nemusel zacinat cislem 1 ale treba od cisla 55)

Poradite nekdo jak na to?

[navstevnik]

to dhous:
Excel pro makra (procedury) pouziva VBA, takze v dotazu uvedeny zapis pozadujes "prelozit" do VBA nebo neco jineho?

[dhous]

Pravdepodobne ano, pres VBA.
Takto komplikovany prevod xls do vyse popsaneho formatu (asi TXT vystup) je uz pro mne "vyssi divci"

[navstevnik]

Nejak nerozumim tomuto:

prevod xls do vyse popsaneho formatu (asi TXT vystup)

Pozadujes v Excelu generovat a vyhodnocovat otazky z tabulky za pouziti VBA nebo pouze pouzit excelovskou tabulku v jine aplikci coby zdroj dat?

[dhous]

Ne potrebuju pouze prevest data z excelovske tabulky do vyse popsaneho formatu - nic vic, nic min. Zadne vyhodnocovani. Jen konverze.