+ Reply to Thread
Results 1 to 7 of 7

Run time error 50290 method 'ontime' of object '_application' failed

  1. #1
    Registered User
    Join Date
    07-25-2006
    Posts
    2

    Run time error 50290 method 'ontime' of object '_application' failed

    Hi I have an excel file and when i open it :
    Run time error 50290 method 'ontime' of object '_application' failed appears,
    and i can only choose "end"

    http://www.traderant.com/images/traderant blog/027.png



    It only happens to one of my computer, and it happens randomly, meaning some time it opens ok, and sometime the run time error appears.

    When I move the file to another computer, there is not such issue.

    Wondering what is the problem. thx

    Ant

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    Hi,

    It's probably a macro driven by the workbook open event. When you've cleared the message by selecting End, go to Visual Basic - Alt-F11, find your workbook name in the left hand window and double click on the 'This Workbook' object. Then in the left hand drop down window on the right click workbook and see what code there is on the Workbook_Open procedure. Delete it if you don't want it.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-25-2006
    Posts
    2

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    Hi,

    there is nothing in the workbook oject

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    Hi,

    In that case would you upload the workbook?

  5. #5
    Registered User
    Join Date
    01-17-2012
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    I use Excel 2010 and I'm having the same problem (Error 50290).

    I have been searching about this for a little while and it happens when for some reason, the application becomes "not ready" (Application.Ready = False) .

    When this error appears, I can check in the Immediate Window that Application.Ready = False. Any suggestions on how to solve this?

    PS:

    If click 'STOP' my Excel crashes...

    I already tried to turn off the AutoRecovery Save, the Multi-Threaded Calculation (For Excel 2003, this Error is not so frenquently) and the Background Error Checking as well.

    When this happens, I can't plot on the sheet (Cells(1,1) = "ok"), I can't activate the Workbook (ActiveWorkbook.Activate), I can't calculate the Workbook (Calculate), nothing.

  6. #6
    Registered User
    Join Date
    05-08-2012
    Location
    Golden, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    I have just run into a similar problem with this runtime error 50290. I have code that runs reliably on Excel 2007. Two installations on Excel 2010 also work. But on a third installation, it hit an error right here (red code):
    Please Login or Register  to view this content.
    by adding this line in red (below), the problem want away.
    Does anyone have any idea why?
    Please Login or Register  to view this content.
    thanks

  7. #7
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Run time error 50290 method 'ontime' of object '_application' failed

    Hello flyboy54.

    You have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1