+ Reply to Thread
Results 1 to 9 of 9

Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

  1. #1
    Registered User
    Join Date
    09-06-2014
    Location
    Toronto
    MS-Off Ver
    MSO 2010
    Posts
    4

    Question Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    Hi everyone,

    Thanks for looking into my post. I am new to this forum and I don't have much knowledge about vba. The problem now is our office just upgraded our office suite to 2010, and our excel file for our label printing template has shown the error every time we start:

    Run-time error '-2147024809 (80070057)' Item with specified name wasn't found


    and it comes from the code:
    Please Login or Register  to view this content.
    but everything was fine when we were using xp with office 2000, and I verified the form name has the correct spelling. I have attached the file on this post, it would definitely help us a lot if we can get this fixed, thanks again!
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    The error is actually here.
    Please Login or Register  to view this content.
    I can't find any controls with a name that begins with 'serialTable' on the userform.

    Even if you had a control with an appropriate name I don't think it will have a Cells property, unless it's a SpreadSheet control.

    Do you have any spreadsheet controls on the form?
    If posting code please use code tags, see here.

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    On that form there is plenty of space for a control to display equipment serial number and as Norie I also think there was some additional control.
    Is it possible that on the old computer you had some additional control registered with excel and a reference to it in the file? When the file was opened for the first time and control was missing on that machine, I think control was deleted and reference removed. This happens too often with me, when I forget to install Microsoft Common controls OCX file (in order to use Date And Time Picker control) before let the user open the add-in, which I developed.
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Registered User
    Join Date
    09-06-2014
    Location
    Toronto
    MS-Off Ver
    MSO 2010
    Posts
    4

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    thx all for the reply, actually I still have 2 pc still haven't upgrade yet, and the excel is still functional on them, is there anyway that I can check the control file that is associate with them? thanks again!!

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    Are you using any non-standard controls, eg spreadsheet controls, date pickers etc, on the form?

  6. #6
    Registered User
    Join Date
    09-06-2014
    Location
    Toronto
    MS-Off Ver
    MSO 2010
    Posts
    4

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    Im sorry I am not sure because he person who create this excel file has left our company, but we use bar-code scanner to do the input for those two fields if that helps.

  7. #7
    Forum Contributor
    Join Date
    08-14-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    135

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    In vba you can open up tools>references to check for missing items. Seems you lost a dll file(s) in the switch

  8. #8
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    In VBE, open Tools->References on both machines - old PC and new one. Compare what references you have in each of them and if there is any difference, in the bottom part of the window you can check the path to the respective dll/ocx file that is present on the old machine and is missing on the new one.

  9. #9
    Registered User
    Join Date
    09-06-2014
    Location
    Toronto
    MS-Off Ver
    MSO 2010
    Posts
    4

    Re: Run-time error '-2147024809 (80070057)' Item with specified name wasn't found

    Thank you everyone for your input, I will try your method and let you know did it work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Run Time Error -2147024809 (80070057)
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2014, 11:51 AM
  2. The Item With the Specified Name Wasn't Found
    By Ted Soper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2013, 11:04 AM
  3. [SOLVED] Run-Time Error '-2147024809 (80070057)': Could not find the specified object
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2013, 12:44 PM
  4. Replies: 1
    Last Post: 11-17-2012, 11:10 PM
  5. Replies: 11
    Last Post: 03-08-2006, 07:10 PM

Tags for this Thread

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