Hi there,

I am working on a Quiz in ppt. On the final slide my students get to see their results (amount of correct/wrong answers, grade, etc.)

With the code: xlsWB.SaveAs ActivePresentation.Path & " \ " & Slide7.TBName.Value & " - Quiz Analysis.xlsx"'
I get students to generate an excel file on their computer, but ofcourse as a teacher I'd like it to be generated online in my OneDrive (for Business) or in Google Sheets.

Even better would be if I could get all the results gathered in one and the same online sheet (or at least in a combined file).

Can anyone help me further? Thanks in advance!