Excel Com Automation
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.
|