:-D I agree Collie x JR, oh boy you are going to have twice the work, but twice the love too. ;-)
Apart from everything already said which will work in time, be assured of that ;-) if he really does go absolutely manic with excitement and leading and putting him in another room or even outside does not stop his high pitched squealing and whining, try something I used to have to do with my mum's terrier x when she was a pup, she was very much like yours extremely excitable and I know the noise you are talking about

whenever we had my neices and nephews or the boys friends around when I was looking after my mum's dogs, this is what I used to do with her.
I would set up the crate in my bedroom and pop her in with water and a knuckle bone, then drape a cloth over it so that she could not see, and close the bedroom door, not being able to see out would make her just sit down eat her knuckle or go to sleep, people could come and go and she would not make a sound, if they were staying for just an hour or so I would leave her in there, if they were here all day she would be let out after an hour, popped on a lead and led into the room with everyone, the children were asked to ignore her completely whilst we walked through, I would then walk her back in and they could all give her a little pat and stroke, if she started up again I would pop her back in for another 20 mins and then let her out again, and try the process again and bingo she behaved impecably, and went to settle down with the other dogs and played nicely with the children, without the noise or over-excitment.
It did take a few times to get her to behave like the other dogs, but dogs learn very quickly, but it does work and believe me she really was a handful, it takes the stress away from visiting as she was quiet upstairs and eventually she learnt that over-excitedness got her back in the crate.
Today she is a dream to have, impecably behaved and very loving and obediant.
Good luck and keep being consistant.