Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 50290: Error writing to Worksheet while using an ActiveX Control
Has anyone ever encountered error 50290 ("Application
defined or object defined error") when trying to write to a worksheet containing a 3rd party ActiveX Control? (i.e., The line 'Worksheets("Sheet1").Range("A1").Value = 1' causes an error.) This error seems to occur ocassionally and spontaneously. I have tried everything, but I know I'm not alone. (Search Google for Excel Error 50290 and you'll find several hits - but no solutions.) Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 50290: Error writing to Worksheet while using an ActiveX Control
I also ran into this problem lately, I haven't find a
solution yet, but I found something in the Microsoft Knowledge Base about this http://support.microsoft.com/default...d=kb;ja;820595 The problem is this article is in Japanese, and I cannot find the same article under the English version and I don't read Japanese either. Hopefully someone can help, thanks in advance. Fred -----Original Message----- Has anyone ever encountered error 50290 ("Application defined or object defined error") when trying to write to a worksheet containing a 3rd party ActiveX Control? (i.e., The line 'Worksheets("Sheet1").Range("A1").Value = 1' causes an error.) This error seems to occur ocassionally and spontaneously. I have tried everything, but I know I'm not alone. (Search Google for Excel Error 50290 and you'll find several hits - but no solutions.) Thanks in advance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 50290: Error writing to Worksheet while using an ActiveX Control
Aaah, Microsoft. Post a solution, but do it in Japanese. God love ya.
I 'fished your page (http://babelfish.altavista.com/) but the translation is, um, difficult to understand. Imagine Yoda providing MSFT tech support. I have discovered that if you wait for a random amount of time and try again, this error mysteriously goes away. (I do this by using On Error Exit Sub in my WriteToWorkSheet sub.) You obviously miss whatever data was happening during that period of time, but at least your code doesn't die. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 50290: Error writing to Worksheet while using an ActiveX Control
I had this exact error happen to me this week, and found it rathe
frustrating to say the least. Reading this thread at least made i clear that it is a known MS problem. I also could not find any Englis version of the above mentioned MS KB article, but I do have a Japanes technical contact who kindly sent me a translation. Here it is: ================================ The run-time error 50290 could occur when executing an Excel macr created by Excel 2000 or an earlier version on Excel 2002. This i because of a specification change of automation processing in Exce 2002. When an automation related method is called, or when an automatio related property is set, Excel 2002, as an automation server, firs checks whether Excel is doing another processing such as handling dat input by user. In case of a program that handles some events durin communication with an external component such as ActiveX Control, Exce can sometimes be unavailable temporarily. If automation communicatio is requested at this timing, Excel will return this run-time error. Solution is to check the Ready property to run your code only whe Excel is ready for automation communication. This property is newl available with Excel 2002. Here's a sample program on how to use th Ready property. 'When Excel version is 2002 or later If Val(Application.Version) = 10 Then 'Check the application status to see if it is available fo processing. If Application.Ready = True Then <Describe what you want to do here End If 'When Excel version is 2000 or earlier, continue the processing Else <Describe what you want to do here End If Note 1: There is no way to know at what timing the Ready property ca become false. When you run a program that makes some events happe during communication with an external component, it is recommended tha you add a statement to make sure the Ready property is true. Note 2: The sample program above will not do anything when the Read property is false. If you want to force changing the value from fals to true, you need to add additional codes doing so, such as sending a Esc key by the Sendkeys statement. ===================== -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Insert Function next to formula bar gives Run-time Error '50290' | Excel Discussion (Misc queries) | |||
Excel VB Run-time error '50290' | Excel Worksheet Functions | |||
how do you use the ActiveX Calendar control in an Excel Worksheet. | Excel Worksheet Functions | |||
ActiveX Error w/Calendar Control | Excel Programming |