Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Number 57121
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime error 57121 | Excel Discussion (Misc queries) | |||
RunTime Error 57121 | Excel Programming | |||
57121 error, but not a Mac in sight | Excel Programming | |||
###Error 57121### | Excel Programming | |||
error 57121 | Excel Programming |