Main Board > Programming

search installed Excel

(1/2) > >>

Thomas Bock:
Hello List ... oops ... Everyone

Currently we're looking for an installed Excel with
call "[LCL]*win/registry", err = *next, "HKEY_CLASSES_ROOT", "Excel.Application\CurVer", $$, dummy$

This doesn't work for an installed Excel-App.
Looking for a registered extension with
call "[LCL]*win/registry", err = *next, "HKEY_CLASSES_ROOT", "SystemFileAssociations\.xls\shellex", $$, dummy$
is not a possitive replacememt, because OpenOfficeCalc may have registered it.

Does someone know a way how to figure out an installed Excel-App?

Regards

Mike King:
Funny you should ask about this.  We are in the middle of adding a similar check to a PxPlus utility due to recent changes in Windows 10.

The logic we are testing is:


--- Code: ---call "[lcl]*win/registry;read",err=*next,"hkey_classes_root","excel","",_X$;
        if _X$<>"" then print "Excel Installed"
--- End code ---

So far in our limited testing this appears to work.

Thomas Bock:
That doesn't work here. Neither on the Surface Book (Excel-App), nor on my desktop (Excel 365). We're using PxPlus V14 SCS. Both throw an error 11.

Mike King:
Perhaps it is using the 64 Bit version of Excel and since PxPlus is a 32 Bit application the system is checking the 32 bit registry.

The registry accesses may need to be changed to:

call "[lcl]*win/registry;read",err=*next,"hkey_classes_root","excel","",_X$,0,64

The issue of different registries was mentioned in a Topic in the FAQ in the Knowledge base section
https://forum1.pvxplus.com/index.php?topic=22.0

Thomas Bock:
That doesn't work either. There is simply no entry hkey_classes_root\excel, but there are very much entries hkey_classes_root\excel.<something>.

Navigation

[0] Message Index

[#] Next page