PDA

Click to See Complete Forum and Search --> : Excel recalculating


sp007
Apr 16th, 2000, 02:42 AM
Is there any way to get excel to automatically recalculate the cells with equations without having excel open using ADO?

JHausmann
Apr 16th, 2000, 05:51 AM
OLE.

sp007
Apr 16th, 2000, 05:59 AM
How would I set it up to a data control?

JHausmann
Apr 17th, 2000, 12:16 AM
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).