You may consider getting some company for him...another dog or a cat?
There are also dog walking services you can hire to come and walk the dog, there is "doggy daycare" as well where you take the dog to them.
Anither opiton is a neighbor that you trust with a dog who may be willing to watch him during the day.
Just some ideas. Congratulations on joining the yorkie world!