Office XP: runtime error 50290 Application Defined or object defined

[nkardas]

Hi,
I use a VBA add-in to write into a Excel worksheet. This add-in uses a
dll to get Real Time data from a server.
Everything works perfectly on Office 97 and office 2000.
I have an issue with OfficeXP: sometime (yes, it does not happen all
the time...), when the VBA add-in tries to write into an excel sheet,
I get the following error:
runtime error '50290' Application Defined or object defined error

The line where it breaks is:
Wb.Worksheets("Sheet1&quot.Cells(RowNbr,ColNbr).Value = myValue

myValue is an Integer, less than 100
Wb is the workbook object
RowNbr and ColNbr are Integer (their value is less than 10)


I need help. I have looked in many newsgroups but I cannot find what
is the issue. I have a deleverable on Wed this week...

Thanks.

 

[Knigal]

Hi, Did you ever get an answer to this problem?
runtime error '50290' - I also get it every now and then !!
I very much look forward to hearing from you - Alex

 

[gtaylor100]

Anyone know the answer to this as i'm tring to find the solution too.

 

[brd24gor]

Ahh, gotta love MS support. Apparently the only article they have on their KB for this problem is in Japanese. However, here is a thread I found that contains a translation of the article:

http://www.msusenet.com/archive/index.php/t-487755.html

Hope this helps,
--Brad

 

[gtaylor100]

Cheers for the info. Tried what they said and it doesn't work. I got round it by Trapping the Error using On error and putting in a goto to a label where the errors happening. Eventually it runs the offending command.