Application.Evaluate("5705")

W

witek

Hi guys,

Could you try something for me?

Open Excel, go to vbe, open immediate window and execute

? Application.Evaluate("5705")


Could you tell me what value you get and why I get -4146
Thanks
 
R

Rick Rothstein

I think you should tell us which version and Service Pack of Excel you are
using and which operating system it is running on. I am using Excel 2003 SP
3 on Vista Ultimate and that expression prints 5705 for me.
 
R

Rick Rothstein

I just fired up my XL2007 SP2 and the expression prints out 5705 on it as
well.
 
W

witek

Rick said:
I think you should tell us which version and Service Pack of Excel you
are using and which operating system it is running on. I am using Excel
2003 SP 3 on Vista Ultimate and that expression prints 5705 for me.
Click to expand...


Excel 2003 (11.8307.8221) SP3

Server 2008 64, Windows XP. It does not matter.

It is even more weird.
It gives -4146 during debugging in one instance of Excel . If I run
another instance of Excel at the same time it gives right value.

Any idea?
 
W

witek

witek said:
Hi guys,

Could you try something for me?

Open Excel, go to vbe, open immediate window and execute

? Application.Evaluate("5705")


Could you tell me what value you get and why I get -4146
Thanks
Click to expand...


More fun

? Application.Evaluate("5705")
-4146
5705
-4146


5705 is when my file is closed.
-4146 when my file is open
 
Top