Animating a Rope

I want to do an animation of a starship firing a harpoon with a cable attached into another ship. How would I accomplish this?

Im bad at explaining, so here is a quick blend to show you how I would do it :slight_smile:

Wireanimating.blend