how to open a sunroof manually

This might help with repair itself: https://www.youtube.com/watch?v=sR8kHMxiemw

Open the trunk, in the left side panel there should be an access panel. Open that (if it's not there just remove the whole panel), you should see a white hex nut. If you have the original tool kit you can use the hex wrench and screwdriver to turn the nut, if not grab a 17mm socket from your garage. Hope that helps.