Run-time error 57121

Posted on 2011-10-19
Last Modified: 2012-08-13
My workbook was created in 2010 and needs to run under 2003. There are some macros in the workbook. When I open it in 2003 it goes through a conversion and then pops up:
Run-time error 57121
Application-defined or object defined error and debugs at the With state:
Sub Workbook_Open()
Dim ws As Worksheet
With Sheets("Home").OLEObjects("cboSelectSpreadsheet").Object
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> "Home" Then .AddItem ws.Name
    Next ws
End With

End Sub

Open in new window

This workbook works fine in 2010 but the users use 2003
Question by:Frank Freese
    LVL 37

    Accepted Solution

    What type of object is cboSelectSpreadsheet?
    If that object type is new to 2007/2010, then you may need to change it.

    I would recommend saving the spreadsheet (from your 2010 machine) as a 2003 version. The conversion works a lot better that way and it will warn you about things that might not convert well.
    Just hit "Save as..." and find the 97/2003 .xls option.

    Author Comment

    by:Frank Freese
    the object in question is a combo box.
    when trying to save as 2003 wb I'm advised some functionaly maybe lost

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now