View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ludek Ludek is offline
external usenet poster
 
Posts: 2
Default Excel automation - formula

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