Macro to Tally Survey Results from Multiple Workbooks in a Folder

Hello guys,

im new to the forum and quite pleased with my first search. Not sure I can write on a closed post???
however my try with this macro does not work.

i have changed the questionnaire to fit my purpose and when I run the macro I get a "already open file message" then it crashes each time.

I attach the file and a sample of a questionnaire.

Thanks in advance for ur help :cool: