ERROR: Exception from HRESULT: 0x800A03EC on Microsoft.Office.Interop.Excel.Application

Question

I got an wired issue when set a formula onto a excel cell by Microsoft.Office.Interop.Excel.Application.
the wired thing is, this app runs well on any others user's desktop but one user - same OS(windows XP + Office 2007).
I degugged the code and get the line which generated the exception.
but if I put try...catch.. and generate the excel file, the manually put the formula(which could be exported in the try-catch caluse) to that perticular cell, it works without any complainents - it only complains when in the running code!

here is the small piece of code I am using:

Dim rg As Range = CType(xsheet.Cells(456,77), Range)
rg.value="0"

rg.Formula = "=sum(BW467,BX467)"
rg.Calculate()

Could anybody help please?

Thanks.

Answer 1

Please post Office Development issues to Discussions in Office Developer New Users for better helps:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.officedev&lang=en&cr=US

---

Best regards,
Riquel
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.