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.