Main Board > Programming
search installed Excel
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
Go to full version