MS Office Click To Run & OLE

[hua]

Hi guys,

One of our customer recently upgraded her Office 2007 with Office 2016.

After the upgrade one of the our report options that exports data directly into Excel using OLE always ends up with a run time error.

Any idea how to get this fix?

TIA

[hmpaquito]

Hi,

Call stack and description error is neccesary.

Regards

[stefano]

you have to change the excel settings.
now I'm on vacation ...

Saluti
Stefano

[hua]

Hi,
Call stack and description error is neccesary.

Thanks for the reply. If I recompile the program using Harbour, it will simply terminates silently. No message whatsoever.

If I compile it using xHarbour, I'll get the following error message

Code: Select all  Expand view

   Error description: Error Excel.Application:ACTIVESHEET:CELLS/0  S_OK: SELECT
   Args:

Stack Calls
===========
   Called from: source\rtl\win32ole.prg => TOLEAUTO:SELECT(0)
   Called from: .\xport.PRG => XPORTPAY:END(166)

That line simply has the code

Code: Select all  Expand view

oSheet:Cells( ::nRow, 1 ):Select()

[hua]

you have to change the excel settings.
now I'm on vacation ...

Thanks for the reply Stefano. Hope to get your input once you're able to check what the setting was.

Thanks.