Page 1 of 1

error oBrw:ToExcel

Posted: Tue Jan 09, 2024 4:38 pm
by 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

Re: error oBrw:ToExcel

Posted: Tue Jan 09, 2024 5:07 pm
by karinha

Re: error oBrw:ToExcel

Posted: Wed Jan 10, 2024 2:37 am
by 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

oWin:FreezePanes := .t.
Replace with:

Code: Select all | Expand

   TRY
      oWin:FreezePanes := .t.
   CATCH
   END