Thanks for the program, it works really fast. However, I get this error when i'm writing to an xlsx file
Error using Interface.Microsoft_Excel_14.0_Object_Library.Workbooks/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Excel cannot open the file 'Splinefit.xlsx' because the file format or file
extension is not valid. Verify that the file has not been corrupted and that the file
extension matches the format of the file.
Help File: xlmain11.chm
Help Context ID: 0
Error in HDD_spline_fit (line 35)
ExcelWorkbook = Excel.workbooks.Open(File);
In which Splinefit.xlsx is the target file.
If I try to write to an .xls file, thus Splinefit.xls, the error does not arise.
As I'm using a predefined xlsx file, switching to .xls does not really work for me.