Hi

I have a Excel template which is working fine in office 97 but when I
am trying to run it on Office 2003 it gives me a run time error 1004
"Application Defined or Object Defined Error " during completion of
process which means it runs for 30 minutes without error and it throws
me an error in the end.Could any one help me on whats happening?

If you describe what the macro is supposed to do, and where it gets
stuck, and include the code, someone may be able to help.

Lakshman wrote:
I have a Excel template which is working fine in office 97 but when I
am trying to run it on Office 2003 it gives me a run time error 1004
"Application Defined or Object Defined Error " during completion of
process which means it runs for 30 minutes without error and it throws
me an error in the end.Could any one help me on whats happening?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hi
Thanks for the reply.To state the fact I am d not aware of what it is
actaully supposed to do,I am just copying the templates from off97
machine to off2003 machine and running it from off2003 machine to make
sure that its working fine.

Regards
Lakshman

Debra Dalgleish wrote:
If you describe what the macro is supposed to do, and where it gets
stuck, and include the code, someone may be able to help.

Lakshman wrote:
I have a Excel template which is working fine in office 97 but when I
am trying to run it on Office 2003 it gives me a run time error 1004
"Application Defined or Object Defined Error " during completion of
process which means it runs for 30 minutes without error and it throws
me an error in the end.Could any one help me on whats happening?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

If you can find out what it's supposed to do, or post the code here,
someone may be able to help. Without a few clues, it would be very
difficult to figure out what's wrong, or how to make it work.

Lakshman wrote:
Hi
Thanks for the reply.To state the fact I am d not aware of what it is
actaully supposed to do,I am just copying the templates from off97
machine to off2003 machine and running it from off2003 machine to make
sure that its working fine.

Regards
Lakshman

Debra Dalgleish wrote:

If you describe what the macro is supposed to do, and where it gets
stuck, and include the code, someone may be able to help.

Lakshman wrote:

I have a Excel template which is working fine in office 97 but when I
am trying to run it on Office 2003 it gives me a run time error 1004
"Application Defined or Object Defined Error " during completion of
process which means it runs for 30 minutes without error and it throws
me an error in the end.Could any one help me on whats happening?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hi
Thanks for the reply.The overview of what I am doing is running the
template in off2003 (Which was running well in off 97 ) for which you
have to give one excel file filled with some data as the input and this
template start processing the data and provides summary based on the
input on the same input file creating another sheet.

The Point where It gives me error is in ac function

Var_total = cell(inttotalrow,intcol).Formula

When the cursor reaches this point it throws an error saying "Runtime
Error 1004 - Application error or Object Defined Error "

Hope this will help in identifying the cause.

Thanks & Regrads

Lakshman.

Do you happen to know the values of inttotalrow and intcol when the
macro crashes? If they are outside the physical boundaries of the sheet
(65536 and 256) then this would give rise to a run-time error.

As Debra said, it is difficult to diagnose the problem without more
detail. Copy the macro here and someone might be able to help further.

Pete

Lakshman wrote:

Hi
Thanks for the reply.The overview of what I am doing is running the
template in off2003 (Which was running well in off 97 ) for which you
have to give one excel file filled with some data as the input and this
template start processing the data and provides summary based on the
input on the same input file creating another sheet.

The Point where It gives me error is in ac function

Var_total = cell(inttotalrow,intcol).Formula

When the cursor reaches this point it throws an error saying "Runtime
Error 1004 - Application error or Object Defined Error "

Hope this will help in identifying the cause.

Thanks & Regrads

Lakshman.

Hi
Thanks for the reply,The Value of inttotalrow and intcol are
(2849,35) and the cell which it is referring is containning a
formala,My main query is when this is workig very well in Excel 97 why
it is not working in Excel 2003 ?

Yes I know it will be difficult without the code,but the thing is I am
not allowed to paste the code....Thats the reason.Sorry for that.

Regards

Lakshman

Well, I'm sorry - I don't think anyone will be able to help you without
any further details.

Pete

Lakshman wrote:

Hi
Thanks for the reply,The Value of inttotalrow and intcol are
(2849,35) and the cell which it is referring is containning a
formala,My main query is when this is workig very well in Excel 97 why
it is not working in Excel 2003 ?

Yes I know it will be difficult without the code,but the thing is I am
not allowed to paste the code....Thats the reason.Sorry for that.

Regards

Lakshman

HI

Thanks for the reply.I have one more query can any memory problem be a
cause of it?.I debugged the code and when it was throwing the error at
that time the cell it was pointing to was holding reference of around
sum of 130 cell values in a formula.May be it doesnt make sense,but
just wanted to check.

Regards

Lakshman

Pete_UK wrote:
Well, I'm sorry - I don't think anyone will be able to help you without
any further details.

Pete

Lakshman wrote:

Hi
Thanks for the reply,The Value of inttotalrow and intcol are
(2849,35) and the cell which it is referring is containning a
formala,My main query is when this is workig very well in Excel 97 why
it is not working in Excel 2003 ?

Yes I know it will be difficult without the code,but the thing is I am
not allowed to paste the code....Thats the reason.Sorry for that.

Regards

Lakshman

Yes, there is a limit to the length of a formula - 1024 characters, so
depending on how your sum formula was formed this might have hit the
limit. There is also a limit of 30 arguments in a function, e.g. if you
have =SUM(a, b, c, d ... etc), you will only be allowed 30 of them.

Hope this helps.

Pete

Lakshman wrote:

HI

Thanks for the reply.I have one more query can any memory problem be a
cause of it?.I debugged the code and when it was throwing the error at
that time the cell it was pointing to was holding reference of around
sum of 130 cell values in a formula.May be it doesnt make sense,but
just wanted to check.

Regards

Lakshman

Pete_UK wrote:
Well, I'm sorry - I don't think anyone will be able to help you without
any further details.

Pete

Lakshman wrote:

Hi
Thanks for the reply,The Value of inttotalrow and intcol are
(2849,35) and the cell which it is referring is containning a
formala,My main query is when this is workig very well in Excel 97 why
it is not working in Excel 2003 ?

Yes I know it will be difficult without the code,but the thing is I am
not allowed to paste the code....Thats the reason.Sorry for that.

Regards

Lakshman

Hi

One quick update needed ,i tried to put On error resume next in the
function where it was giving error and it executed fine till the end?Is
it throwing some kind of clue.I compared the results also ,it looks
same thou i didnt check in detail.


Thanks & Regards

Lakshman