That Yes may even turn to a No, but you feel pretty damn good even getting that initial Yes.
I hate to break to you, but you may as well get used to hearing "no" in Hollywood. It's a knee-jerk reaction. No, I won't fund your film. No, I don't like your script. No, you can't have that actor. No, you aren't invited to that premiere. No, you can't get in that party. No, you aren't accepted to that festival. No, you didn't get that job. Just face it: No is a popular word and Yes is what you will be chasing the rest of your career. When you get them, you better cherish them for another one may not come around again for a long while.
So how do you deal with all the "No"s? You just do. You let those countless "No"s roll off your back and you try to learn from them. Why did he or she say no? There's a reason for everything. And if you can hone in on that reason, you may be able to focus on why you aren't hearing the elusive "Yes"! Or maybe that person is just a tool. Could be the case. You never know.
If you let them, the "No"s can also be very inspiring. Every time I hear a "No," I get fired up. I think, "What the hell do I have to get a 'yes' around here" -- alright, get your heads out of the gutter... And I buy that revealing dress (just kidding; wanted make sure you were still paying attention). In all seriousness, I work even harder and I set out to keep making more quality films. Boy that sounds really boring. But it's the truth.
Each day, I think of new stories. I write. I read books and magazines and the news. I watch a crap-load of movies and TV shows. I troll the internet (again, minds out of the gutter, please), and I look for inspiration for new kick-ass ideas that can translate to the big screen. The key is hearing that "No" and kicking that negative energy right on out of your living room. Just get it out. Don't accept it.
Remember: All it takes is ONE (IN THE BIGGEST LETTERS POSSIBLE) YES! That's right. Just one "yes" is all you need. You may hear five million "no"s but that one "yes" could be number five million and one! Just keep at it and keep getting better.
Pangofilms (see Comments) makes a great point. Don't take it personally. That is the most fundamental step to dealing with "No"s. Filmmaking is a business. And not everyone is going to like your work. That is a fact. So get comfortable with that fact and find your audience who does like your work and cater to them.