Is there any way to get excel to automatically recalculate the cells with equations without having excel open using ADO?
Printable View
Is there any way to get excel to automatically recalculate the cells with equations without having excel open using ADO?
OLE.
How would I set it up to a data control?
You can't link OLE, afaik, to a data control. You can, however, open a worksheet and it will re-caclulate the sheet on open (or whenever you instruct it to).