I don't have xl2k installed, so I can't test to see if causes trouble.

But in xl2003, there's a difference in those constants:
?xlvalues
-4163
?xlvalue
2
(from the immediate window in the VBE)

Maybe you can check if the constants are the same in xl2k.

Or maybe xl2k is just more forgiving????

I've never noticed a difference in speed between xl2k and xl2003.

But maybe I've never done the "fetching" you have.

If you describe what you "fetching" means, maybe someone who has done it like
you have will have an idea.

Prince wrote:
<<snipped

Yes Dave,

I found that and it is working but yes i was just wondering how come
xlvalue work in xl 2000 but it fails in xl2003. I had made the
following change and it worked.

Please tell me if you know the reason for that bcoz i have debugged
the code in xl2000 and there it is not giving any error.

Thanx a lot for your cooperation and guidance.

I was doing the migration of the application to xl2003 hence i am
haviong lot of queries. Some of them a

The fetching of the data from the excel sheets by variouis formulaes
into the corresponding screen is taking just the double time in the
application 2003.

Hence I was wondering and trying to find out the reason.

Can you please tell that has such issues been with excel2003 that the
formulaes and fetching of data if migrated to excel2003 from excel2000
makes the apllication and fetching of data slower.

Regards,

Prince

--

Dave Peterson