Archbishop-designate Weisenburger appointed to Detroit