Excel automation - formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I use FoxPro 7.0 SP1 to Excel 2000 automation. I have problem save formula to Excel sheet. I create Excel object, Workbook, ...and then I will put formula

oe.cells(24,7).Formula = "=G6+G7"
.... work O
oe.cells(24,8).Formula = "=SUMA(G6:G7)"
..... cell display #NÃZEV?
oe.cells(24,9).Formula = "=KDYŽ(I6=2;H6;0)"
....error Debugeru FoxPro: OLE IDispatch exception code 0 from ?:?.
I have international (localized) version of Excel - Czech
Thank Yo
Ludek
 
You need to use
FormulaLocal =

to enter formulas like you would in the spreadsheet. If you use formulas in
English, then use Formula.

--
Regards,
Tom Ogilvy

Ludek said:
Hi,
I use FoxPro 7.0 SP1 to Excel 2000 automation. I have problem save
Click to expand...
formula to Excel sheet. I create Excel object, Workbook, ...and then I will
put formula:
 
Back
Top