Depends on the formula, but

Results = xlApp.Evaluate(StrFormula)

should work.

The formula must be specific in terms of the ranges it addresses.

Many Worksheetfunctions can be used in VBA directly.


Results=xlapp.Sum(Worksheets("Sheet1").Range("A1:A 200"))

--
Regards,
Tom Ogilvy



Carlos Magalhaes wrote in message
...
Yeah I was HOPING that was not the only option, I really dont want to
write anything to that file I just want to apply the formula get the
data and close the file.

Not possible ??


On Fri, 7 Nov 2003 19:37:24 +0200, "Haldun Alay"
<haldunalayATyahooDOTcom wrote:

Hi,

Use Saved property of workbook. Set it TRUE before closing the workbook.