I am writing a program using Office templates, and I want to write a formula in an Excel cell. For example, in K3 I want to write “= (I3 * J3)”.
I can’t find how to do that. If i use
MsExcel.Assign (‘K’, 3, ‘= (I3 * J3)’) when I open the results excel file, the cell show = (‘I3’ + ‘J3’) and obviously this doesn’t work.
Does anyone know how to do this?
Thanks in advance!
Sorry! I found the solution!!!