Error No 50290
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business
Runtime Error 50290
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation run-time error 50290 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like
Run-time Error '50290' Application-defined Or Object-defined Error
you, helping each other. Join them; it only takes a minute: Sign up Run-time error '50290': Application-defined or object-defined error Excel up vote 1 down vote favorite I've use asynchronous WinHTTP in Excel VBA to shoot out run time error 50290 method of object failed a lot of requests to a website. After the reply is received, a module is called which writes to the sheet. Generally this works fine, but if the user does not have the focus on Excel, it will error out with a "Run-time error '50290': Application-defined or object-defined error". It specifically errors out on this line: pcol = ThisWorkbook.Worksheets("WHA").Cells.Find("PRODUCTA").Column I tried the following syntaxes as well: pcol = Sheet3.Cells.Find("PRODUCTA").Column pcol = Sheet3.Rows(5).Find("PRODUCTA").Column pcol = Sheet3.Rows(5).Find(What:="PRODUCTA").Column run time error 50290 excel 2010 pcol = Sheets("WHA").Cells.Find(What:="PRODUCTA", LookAt:=xlWhole, LookAfter:=Sheet3.Cells(5, 1)).Column All to no avail... I know I can force the focus back on Excel in VBA,but ideally, I don't mind if the macro runs in the background while the user is getting smarter on stackoverflow.com in the mean time :-) Does anyone have any suggestions on how to overcome this, please? Thanks! excel vba excel-vba share|improve this question asked Jul 23 '15 at 20:49 JasperD 614 Just to be clear - it's not the way I write the code that makes it error (that's why I changed 5 slightly different syntaxes), but it's the fact that the focus is not on excel. If the user keeps looking at excel, it never errors out.... –JasperD Jul 23 '15 at 20:50 The module with the WinHTTP fetch would seem to know where it is. Can you pass the workbook or worksheet object to the module sub 'which writes to the sheet' as a parameter rather than let it discover them itself? –Jeeped Jul 23 '15 at 21:55 Hi Jeeped - thanks for your suggestion! I tried to do this, but it sadly didn't work (so I set global variables that stored workbook & worksheet and I tried passing it when triggering the callback) –JasperD Jul 27 '15 at 20:21 add a comment| 2 An
2003. emblair3 Guest Has anyone ever encountered error 50290 ("Application defined or object defined error") when trying to write to a worksheet containing a
Run Time Error 50290 Method `screenupdating` Of Object `_application` Failed
3rd party ActiveX Control? (i.e., The line 'Worksheets("Sheet1").Range("A1").Value = 1' causes an run time error 50290 excel 2013 error.) This error seems to occur ocassionally and spontaneously. I have tried everything, but I know I'm not
Excel Vba Method Screenupdating Of Object _application Failed
alone. (Search Google for Excel Error 50290 and you'll find several hits - but no solutions.) Thanks in advance. emblair3, Oct 30, 2003 #1 Advertisements Fred Guest I also http://stackoverflow.com/questions/31597777/run-time-error-50290-application-defined-or-object-defined-error-excel 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.aspx?scid=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 http://www.pcreview.co.uk/threads/error-50290-error-writing-to-worksheet-while-using-an-activex-control.957374/ 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. >. > Fred, Oct 30, 2003 #2 Advertisements Edward Blair Guest 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! Edward Blair,
List License Types Product Editions SupportFrequently Asked Questions Online Forums Search ResourcesDocumentation Product Information Knowledge Base Technology: OPC News Archive Developer Blog CompanyReferences Testimonials Partners Contact Us Home | Forum | Discussions | QuickOPC-UA in COM | Reading, Writing, Subscriptions | Cell http://www.opclabs.com/forum/ua-com-reading-writing-subscriptions/1509-cell-update-in-excel-vba-gives-runtime-error-50290 update in Excel VBA gives runtime error 50290 IndexRecent TopicsSearch Welcome, Guest Username: Password: http://p2p.wrox.com/pro-vb-6/71238-error-50290-vba-excel-2003-doing-strange-thing.html Remember me Forgot your password? Forgot your username? Create an account Forum Discussions QuickOPC-UA in COM Reading, Writing, Subscriptions Cell update in Excel VBA gives runtime error 50290 Threaded Indented TOPIC: Cell update in Excel VBA gives runtime error 50290 Cell update in Excel VBA gives runtime error 50290 08 Jan 2015 11:39 #2587 support OFFLINE time error Moderator Posts: 1508 Thank you received: 209 From: C. Sent: Wednesday, January 07, 2015 4:40 PM To: Zbynek Zahradnik Subject: Questions about VBA [...] I have more questions that I can’t figure out and I was hoping that you can help. [...] working on using the new UA COM feature to work with UA in Excel. I’ve been looking at the UASubscribeToMultiple example and I have a question on how time error 50290 this works. I’m not super familiar with VBA and I couldn’t find anywhere online that addresses this, so I’m sorry if this is a dumb question. After the tags are subscribed, I can see values in the appropriate cells updating. If I click in a different cell (say E2) to edit something, all the updates in the other cells stop. If I click out of E2, the updates for the other cells continue. I notice sometimes as well, while I am editing E2, a runtime error will get thrown. My assumption is that this is because Excel doesn’t allow us to edit more than one cell at a time, and the MonitoredItemChanged event handler is trying to update another cell while I am still editing E2. If I add an On Error handler that ignores the error, everything continues fine. Doing this would lose the information that that event had, so I guess we would need to cache it somewhere to try to update the cell’s value again if possible if we don’t want to lose any data? My question is – is this an expected feature of Excel? What exactly is going on when I do this? I’m not sure how Excel handles locking cells while they
Unanswered Topics Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6 Error 50290: VBA in Excel 2003 doing strange thing User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) October 29th, 2008, 08:44 AM Andraw Friend of Wrox Join Date: Jan 2005 Location: Houston, TX, USA. Posts: 108 Thanks: 0 Thanked 0 Times in 0 Posts Error 50290: VBA in Excel 2003 doing strange thing Hi, all, I have a project created with VB from which I will load data from DB to a spreadsheet, because it takes time, I also create a small frame on which there is a progress bar. My problems are: 1: while load data to spreadsheet, I use some codes like the following: Worksheets("General Analysis").Activate Range("B10").Select ActiveCell.Offset(I, 0).Value = SF_ID ActiveCell.Offset(I, 1).Value = SF_Toe ActiveCell.Offset(I, 2).Value = fRGv everything is fine, but if I scroll down or click the page, I will get runtime error: Runtime error 50290, application-defined or object defined error" and this error may happen in different line each time. 2: If I don't make the spreadsheet file showing on the window, instead, show progress bar. everything is also fine, but If I click on this form, a system alert will appear with two buttons: Switch and Retry (not all computer has this issue.). How can I avoid these issue. I google this runtime error, a lots of posts but no answer. Thanks! « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page