Have you thought about a doggie daycare or having someone care or check in on him while you are gone. He sounds like he has anxiety when you are gone.
Yorkies love and need to be around people. Just another option that you might try. Maybe one of those "neighbors" could come and play with him!