PB 11.5 to Excel Starter Version

[jbeetz1]

It appears that Microsoft is shipping a starter version of Excel with Windows 7. The OLE call that I currently use Connecttonewobject("Excel.application") does not work. Does anyone know what the call wqould be?

 

[miguelleeuwe]

so this would not work?

OleObject lole_obj
Integer li_ret

lole_obj = CREATE OLEObject
li_ret = lole_obj.ConnectToNewObject("excel.application")
IF li_ret <> 0 THEN
messagebox('debug', 'no luck!')
return
end if
----------------

Then check your registry (run "cmd", then "regedit.exe") to see which versions of Office you have installed:
Myself I found: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Software\Microsoft\Office\14.0]
wich means I'm having Office 2010 installed (not the starter version).

you might have more luck with:
li_ret = lole_obj.ConnectToNewObject("excel.application.14") // office 2010. Note "14" not "14.0"


regards,
Miguel L.

 

[miguelleeuwe]

another thing to remember:

after playing around with connectToNewObject you might have 'halfopened' connections with Excel in task administration. "EXCEL.EXE" Make sure you finish them all before trying to connect again:

regards,
Miguel L.