I'm having some trouble opening a generic Excel File through the Solidworks API. It seems to run fine until it tries to open the file then I get the runtime error 1004. I've enabled the references to the Excel Object Library and checked they are both Version 14. This has got me pretty stumped and I suspect I've just missed something very silly. 

Any help would be greatly appreciated here!