With a friend, we are trying to deal with the connection between excel and GH.
When we tried at home it worked with excel 2003. Unfortunatly, at my office we only have excel 2007 and we get the following result:
Error: old format or the library type is not valide. (exception HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) (line:0)
(I tranlsated from french)
We tried to change :
xlApp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application")
xlApp = Marshal.GetActiveObject("Excel.Application")
But it doesn't work
It seems that it comes from the region setting and the language used by the software. This explanation was found on microsoft forum but we did not find the solution.
Does anybody has a clue to solve this problem but still in GH?
thx in advance