Solved!

WHat happened was that the path to the dll's for the office object library and office excel library were given the wrong paths. I had to re-reference them using the COM tab in "add references"