Hi all,

I was wondering if any one can help me find the veriosn and the service pack
of office from VBA in the code.

eg: I want to know if i am running office 2003 SP1.

How do i do that. Any ideas are greatly appreciated


Regards
Amar

Hi Amar

Application.Version will return the version number of Excel you are
running eg if I type:

?Application.Version

in the Immediate Window of the VBE editor it returns 11.0 (because I
am using xl2003) - I also have 2002 on my machine, and if I type the
same thing in the 2002 VBE I get 10.0. xl2000 would return 9.0 and
xl97 (which I have at home) returns 8.0.

Hope this is helpful!

Richard



On 30 Jan, 07:33, amar wrote:
Hi all,

I was wondering if any one can help me find the veriosn and the service pack
of office from VBA in the code.

eg: I want to know if i am running office 2003 SP1.

How do i do that. Any ideas are greatly appreciated

Regards
Amar

Thanks a lot Richard

Regards
Amar