Well there are some spells in vanilla that give ranged attacks to your hero (Icefloe).
Furthermore, in The Protectors, there are also some items and skills that give ranged attacks to your hero. And in version 0.8.7 there will also be some perks that'll do just that.
WBC3 patched to unofficial version 1.03.23 also has the Fire Missile skill.
I think that's about it. You can mod your hero to either get that skill (using a hero editor) or that item or that spell.