Excel Version

JPHSC

Does anyone know if its possible to read the current excel version from the automation server ?
I need to make a difference between excel 2003 and 2007 users ?

garak

Do you mean this :?:

Name	DataType	Subtype	Length
RecAutomations	Record	Automation Server	

RecAutomations.reset;
RecAutomations.SETfilter(Name,'@*Excel*');
if RecAutomations.findfirst then
  message(RecAutomations.Name + ' ' + RecAutomations.Version);

or this

Name	DataType	Subtype	Length
ExcelApp	Automation	'Microsoft Excel 11.0 Object Library'.Application	

if isclear(ExcelApp) then
  create(ExcelApp);

message(ExcelApp.Version);

Regards

JPHSC

The second one, i cant believe i missed this ...
Thanks .

garak

;-)

Please write [solved] infront of your subject in your first post.

Thanks