Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason

Hi Jason,

Have a look at the following site and see it it gives you a clue as to what
is occurring.

http://www.mrexcel.com/forum/showthread.php?t=24602

--
Regards,

OssieMac


"Jason Zischke" wrote:

Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason

Would suggest to post your macro so that people here can try out and identify
the cause.

--
Jacob


"Jason Zischke" wrote:

Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason

Hi Jacob

The line of code that creates the error is:

ActiveWorkbook.Sheets("Temp").Cells(3, 3).ClearContents

Jason

"Jacob Skaria" wrote:

Would suggest to post your macro so that people here can try out and identify
the cause.

--
Jacob


"Jason Zischke" wrote:

Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason

Jason,

Is the code in a Workbook_Open event or Auto_Open sub?

--
Regards,

OssieMac


"Jason Zischke" wrote:

Hi Jacob

The line of code that creates the error is:

ActiveWorkbook.Sheets("Temp").Cells(3, 3).ClearContents

Jason

"Jacob Skaria" wrote:

Would suggest to post your macro so that people here can try out and identify
the cause.

--
Jacob


"Jason Zischke" wrote:

Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason

Hi OssieMac

Thanks for your help, you gave me my answer. I found that the activeX
controls had been disabled in excel and as soon as I re-enabled them my file
worked again on that computer.

Thanks

Jason

"OssieMac" wrote:

Hi Jason,

Have a look at the following site and see it it gives you a clue as to what
is occurring.

http://www.mrexcel.com/forum/showthread.php?t=24602

--
Regards,

OssieMac


"Jason Zischke" wrote:

Hi All,

I have a problem with one computer that when a open one of my files on it
and run the macro in it it will come up with an error message that says
"Error Number 57121. Application-defined or Object-defined Error" though when
I open it on another computer it works fine. The Computer that I'm having
trouble with is using Office 2007 and my file was orginally made with Office
2003. The file was working on this computer until the begining of this week.

Any Answers would be greatly apprieciated

Jason