Page 1 of 1
MS Office Click To Run & OLE
Posted: Fri Jul 27, 2018 4:51 am
by 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
Re: MS Office Click To Run & OLE
Posted: Fri Jul 27, 2018 10:21 am
by hmpaquito
Hi,
Call stack and description error is neccesary.
Regards
Re: MS Office Click To Run & OLE
Posted: Sat Jul 28, 2018 9:04 pm
by stefano
you have to change the excel settings.
now I'm on vacation ...
Saluti
Stefano
Re: MS Office Click To Run & OLE
Posted: Mon Jul 30, 2018 3:45 am
by hua
hmpaquito wrote: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
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
oSheet:Cells( ::nRow, 1 ):Select()
Re: MS Office Click To Run & OLE
Posted: Mon Jul 30, 2018 4:10 am
by hua
stefano wrote: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.