>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I am using automation to find the CORREL now, but I can't seem to get excel to close. I thought release was supposed to do this:
loExcel=CREATEOBJECT("excel.application")
WITH loExcel
.workbooks.OPEN(lcTempFile)
.RANGE("E1").SELECT
.ActiveCell.FormulaR1C1 = lcCorrelParam
lnCorrel=.RANGE("E1").VALUE
ENDWITH
RELEASE loExcel
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
The release ends your connection to the Excel instance that you created... but keeps the instance out there, spinning around in space.... Try loExcel.Quit just prior to the Release.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell