error oBrw:ToExcel

[damianodec]

Hi,
My app run on 15 pcs but I get error only on 2 pcs

when I call function oBrw:ToExcel() I get this error:

Application
===========
Path and name: myexe.exe (32 bits)
Size: 7,345,664 bytes
Compiler version: xHarbour 1.2.3 Intl. (SimpLex) (Build 20161218)
FiveWin version: FWHX 17.09
C compiler version: Borland/Embarcadero C++ 7.0 (32-bit)
Windows version: 6.2, Build 9200

Time from start: 0 hours 2 mins 31 secs
Error occurred at: 09-01-2024, 17:20:24
Error description: Error Excel.Application:ACTIVEWINDOW/3 DISP_E_MEMBERNOTFOUND: _FREEZEPANES
Args:
[ 1] = L .T.

Stack Calls
===========
Called from: => TOLEAUTO:_FREEZEPANES( 0 )
Called from: .\source\classes\XBROWSE.PRG => TXBROWSE:TOEXCEL( 9095 )


the app run on 10 pcs but I get this error only on 2 pcs

why?

Thanks

[karinha]

https://fivetechsupport.com/forums/viewtopic.php?f=3&t=3950

[nageswaragunupudi]

We get this error with some versions of Excel.

We need to modify xbrowse.prg
Please locate this line of code in the method ToExcel()

Code: Select all  Expand view

oWin:FreezePanes := .t.

Replace with:

Code: Select all  Expand view

  TRY
      oWin:FreezePanes := .t.
   CATCH
   END