topic-35891

Posts: 1096

Joined: Fri Oct 28, 2005 02:27 AM

MS Office Click To Run & OLE
Posted: Fri Jul 27, 2018 04:51 AM

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

FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour

hmpaquito

Posts: 1515

Joined: Thu Oct 30, 2008 02:37 PM

Re: MS Office Click To Run & OLE
Posted: Fri Jul 27, 2018 10:21 AM

Hi,

Call stack and description error is neccesary.

Regards

stefano

Posts: 80

Joined: Tue Mar 25, 2008 09:03 PM

Re: MS Office Click To Run & OLE
Posted: Sat Jul 28, 2018 09:04 PM

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

Saluti
Stefano

FWH 14.11 + xHarbour + bcc582

hua

Posts: 1096

Joined: Fri Oct 28, 2005 02:27 AM

Re: MS Office Click To Run & OLE
Posted: Mon Jul 30, 2018 03:45 AM

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 (fw): Select all Collapse

   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 (fw): Select all Collapse

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

FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour

hua

Posts: 1096

Joined: Fri Oct 28, 2005 02:27 AM

Re: MS Office Click To Run & OLE
Posted: Mon Jul 30, 2018 04:10 AM

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.

FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour

FiveTech Support Forums

Continue the discussion