Thorn
King
Assuming you have the mapscript in the right place (Civ4 directory/Public Maps, NOT in your my documents folder) it should work fine for most mods.
Oops, wrong directory was indeed the problem. I should know better.

Thanks for the help guys. Everything's working ok now!
