• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 643
  • Last Modified:

Run-time error 57121

Experts,
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
    .Clear
    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
0
Frank Freese
Asked:
Frank Freese
1 Solution
 
TommySzalapskiCommented:
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.
0
 
Frank FreeseAuthor Commented:
the object in question is a combo box.
when trying to save as 2003 wb I'm advised some functionaly maybe lost
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now