Multiple File Spell Checking

[wesleyw]

One of the SMT has asked for reports for the pupils to be done via sims but he needs to check all of the word documents that the staff have created for spelling mistakes does anyone know how to spell check several documents at once?

 

Wes

[sahmeepee]

I would imagine it can be done through VBA or VBScript. This Google Groups thread may be of use:

 

http://tinyurl.com/h7whw

 

If he's doing the spellchecking himself I think some sort of VBA macro in Word would be best although it's not going to be much quicker than just opening loads of files and spell-checking them one-by-one.

 

Hopefully he's aware of how much work he might be doing.

[GrumbleDook]

I take it that the reports are done via assessment manager (the text being put into free text boxes).

 

Just create a master data entry marksheet for groups (by form, by subject or by year group) and this can be exported out into Excel. You then use the spell check in excel ... once corrections have been made you the use the same excel file to import back into the mark sheet.

 

Be warned ... the export / import can take some time if done in large groups.