Quiz

Dear Sir,

First of all I would like to thank you for your work and for creating this great and simple to use tool :-)
I came across Excel2GIFT as I was doing research on how to import QuestionPools to ILIAS LMS.
Using your tool to create *.gft files and then converting them with SimpleQuestion tool was the way to go!

While I was going through your original thread, I've noticed that some users were struggling with file formatting for "non-standard" characters.
Since I was interested in UTF-8 compliant output, I was able to "develop" a following solution (with the help of Stack Overflow: Save text file UTF-8 encoded with VBA)
and I would like to share it with you and the comunity below.

In the bottom part of the Public Sub ExportGIFT() VBA module:
1) Comment out the original section:

'Export To Text File
'Application.ScreenUpdating = False
'On Error GoTo EndMacro:
'FNum = FreeFile
'Open FName For Output Access Write As #FNum
'    For q = 0 To 100
'        If qGIFT(q) <> "" Then Print #FNum, qGIFT(q)
'    Next q
'EndMacro:
'On Error GoTo 0
'Application.ScreenUpdating = True
'Close #FNum

2) And replace it with the following one:

'Export To Text UTF-8 File
Application.ScreenUpdating = False
On Error GoTo EndMacro:
Dim fsT As Object
Set fsT = CreateObject("ADODB.Stream")
fsT.Type = 2 'Specify stream type - we want to save text/string data.
fsT.Charset = "utf-8" 'Specify charset For the source text data.
fsT.Open 'Open the stream And write binary data to the object
    For q = 0 To 100
        If qGIFT(q) <> "" Then fsT.WriteText qGIFT(q) 'fsT.WriteText "special characters: äöüß"
    Next q
EndMacro:
On Error GoTo 0
Application.ScreenUpdating = True
fsT.SaveToFile FName, 2 'Save binary data To disk

One small issue that I could not fix:
After opening a *.gft file (created like described above) in Notepad, Notepad++, Firefox, whatever, the file looks good,
but when I open it with SimpleQuestion tool, an unidetified character appears in front of the "credits" section.
This is not a problem, as all you have to do is delete it, and you are ready to go.
Unfortunately I do not run any moodle LMS at the moment, so I cannot verify if this file would cause eny errors on import.
Maybe someone else from community will give it a try :-)

I've attached a screenshot to show how this char looks. When I copied it and pasted in the Character Idetifier website it turned out,
that this is a set of 3 chars: 
U+00EF LATIN SMALL LETTER I WITH DIAERESIS character (ï)
U+00BB RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK character (»)
U+00BF INVERTED QUESTION MARK character (¿)

As raw characters:


Since for my workflow all I have to do is delete it (them?) I did not ivestigate it any further.

Have a nice day!