Create excel file from Access and enter 'Round' function in a cell

[c_breemersch]

Hi,

I create an excel-file with VBA code in MS Access. When I want to enter

"=ROUND(Sum(H26:H30);2)" as the value of a cell, it gives me an object-oriented error, but the formula works perfectly in Excel, so there is nothing wrong with the formula.

Access-code:
mySheet.Cells(irow, 8).value = "=ROUND(Sum(H26:H30);2)"

Is the word "round" interpreted as a vba-function? everything is between quotation marks, so that shouldn't be a problem.

Christophe

 

[chergh]

There is something wrong with the formula namely the semi colon in it. It should be "=ROUND(Sum(H26:H30),2)"

 

[c_breemersch]

Thanks, it works.
(The comma is replaced automatically by a semicolon in the final excel though on my computer)

christophe