I agree with the people above that it all depends on the depth of the letter. Just cause a letter of rec comes from the VP, doesn't mean anything if that person can't write something personal about you. And, just cause he's the VP of the school, may not mean anything to the people who read it. Remember that the importance of the letter of recs isn't really about the person who is writing it...it's about the person it is written for.
When I was choosing some of my letter of rec writers...I had options. I was lucky, I had done a lot of ASB stuff at my school. I could have asked the VP of Student Affairs at our school to write me a letter. His only direct boss is the President of the school, but I opted for other people who knew me better. The people I chose may not have the fancy title...but there letters were probably aces above anything the VP would have been able to write me cause our only relationship was a professional level where I met in council meetings and smaller meeting a couple times a month with him. But..like they said...if he really knows you well, and you don't think there are other people who know you better and could write the letters...than ask him or her.