Determining Excel Version using Labview

[EALEX]

I have a program that writes data to an excel spreadsheet than run a
macro. The target computer for the application may have excel 97 or
excel 2000. Because of subtle difference between 97 and 2000 I am
required to use different macros and some different VI. I would like
to programmatically determine which version of excel is installed.
This will help me to determine which macro and different VI use.

[Brian_Vibert]

Have you tried the version property of the Excel_Application object? I only have 97 here so I can't try it out, but it seems like maybe it would work.

Brian

[Cyril]

Brian is right. Open an automation refnum, create a property node and one of the properties to be selected is "version".It returns the current version of excel in use(Tried it with 97 and 2000)

Cyril