I understand the feelings for your VP. My VP of marketing ($150m company, 350 employees) was at home one weekend, her husband was up on a ladder replacing a light bulb, fell, and died on the spot. The company stepped up and let her do whatever she wanted/needed for as long as she needed. A friend of mine who worked here before I did, was diagnosed with terminal Stage 4 cancer and 6 months to live, when he went in for a dental appointment. The company paid him his full salary, up until the day he died. No questions asked, no expectations on work. Health issues like this are hard enough to cope with alone. But when the company has a heart about it, at least it frees you up from wondering if you are going to be fired for not performing while mourning/dying. Companies can be so heartless. It shouldn't be notable when they are not.
My company is humorless, but we aren't heartless. I'm fairly confident he'll be treated well along the way. The company will largely be by the book, but I think the people will do what we can to help. That includes his boss who I regard as the finest executive we've had as well as all the little individual people like me.