Excel Export (OLE)
I am using FR to create an Excel exportable report that contains, in some cells, Excel Calc calls (ie =A1+A2).
Using the FastExport options and formatting the cells as numeric, this works a treat. Until I start to use Excel Functions like IF or VLOOKUP and then I just get an OLE error 800A03EC. I get this error whenever I use any of the functions so I suspect it is Excel that is generating the error but I'm hoping one of the clever people here may be able to point me in the right direction. I have confirmed the validity of the formulas by entering them directly into the sheet once exported.
Anyone got any ideas? Please?
Using the FastExport options and formatting the cells as numeric, this works a treat. Until I start to use Excel Functions like IF or VLOOKUP and then I just get an OLE error 800A03EC. I get this error whenever I use any of the functions so I suspect it is Excel that is generating the error but I'm hoping one of the clever people here may be able to point me in the right direction. I have confirmed the validity of the formulas by entering them directly into the sheet once exported.
Anyone got any ideas? Please?