If you don't want another puppy, how about a kitten to keep him company. Yorkies do not like to be left alone for long periods of time.
But it does sound like you have spoiled him a bit, and turing your back and walking away will probably need to be done even if you do get him his own pet.
Jeanie |