I got Age of Empires: Collectors Edition and it works fine, needs a bit of messing around with Age of Empires II in the compatibility settings though. Here if you're in the UK.
This probably can be fixed but I'd look for an online download for it. I did the same when I found my old original CDs. I ended up buying this on Amazon, as it was only £5.
You can look through some of these too, bound to be a free download somewhere...