method '`' of object '`' failed

[dr_panicker]

Hi,

I am facing a problem.
I have installed my database application on a client machine .
The application works fine for some time (1 to 2 weeks) after which it crashes down saying
method '`' of object '`' failed
I have resolved this issue by installing vb on clients machine but the same problem reoccured after successfully running for a week .

Can anyone help as to what might be the cause of such an error.

Thanks,

dr_panicker

[csar]

I'm not sure for your object, but I'd an experience about Excel Object. I think it's occured because version conflict or else.

Fortunately, I'd solved this problem by Lated-bind variable declaration.

old code

Dim oAppExcel AS Excel.Application
Dim oExcelSh AS Excel.WorkSheet
Dim oExcelWK AS Excel.WorkBook

to new code

Dim oAppExcel AS Object
Dim oExcelSh AS Object
Dim oExcelWK AS Object

and remove MS Excel Object type library from Reference

[biswajitdas]

re install the vb on the clinet machine and then create the setup on that machine.

after loading the new set up then remove the visual basic.
it sove the problem

Biswajit das