Community

HI @stelpstra, Thank you for sharing your VBA and detailed explanations. I have borrowed extensively from your original work and my code is probably not as elegant as your own, but I share it here as it might be of use to others wanting a course enrolment report. The Excel worksheet below lists students enrolled in a course. In the 'Settings' window there is an option to choose active students or all students including those with a pending/invited status. In the 'Settings' window, the user must also enter their Canvas site URL as well as their own API token (as explained above). The option also exists to use sub-accounts and sections to group types of courses. This needs to have been set up in your Canvas site before you can use the sub-account option. The sections in a course can be listed using a second button on the attached worksheet. By selecting a sub-account ID rather than a course ID, all students enrolled in a group of courses within a sub-account will be listed.  On a separate sheet, is a PIVOT table that groups all enrolled students by course ID and section ID and allows the user to filter students by date and enrolment status. The VB developer code password is REPLACEME. Link to Google Drive with worksheet: Canvas Course Enrolments Report.XLSM (please save the file. It will not work if opened in Google Sheets. Users must also enable macros in Excel for the report to work). David ... View more