Michael Harris has been involved in many royal events during his years in Edinburgh.