error oBrw:ToExcel

error oBrw:ToExcel

Postby damianodec » Tue Jan 09, 2024 4:38 pm

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
FiveWin for xHarbour 17.09 - Sep. 2017 - Embarcadero C++ 7.00 for Win32
FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)
Visual Studio 2019 - Pelles C V.8.00.60 (Win64)
User avatar
damianodec
 
Posts: 422
Joined: Wed Jun 06, 2007 2:58 pm
Location: Italia

Re: error oBrw:ToExcel

Postby karinha » Tue Jan 09, 2024 5:07 pm

João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
User avatar
karinha
 
Posts: 7872
Joined: Tue Dec 20, 2005 7:36 pm
Location: São Paulo - Brasil

Re: error oBrw:ToExcel

Postby nageswaragunupudi » Wed Jan 10, 2024 2:37 am

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  RUN
oWin:FreezePanes := .t.


Replace with:
Code: Select all  Expand view  RUN
  TRY
      oWin:FreezePanes := .t.
   CATCH
   END
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10690
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 72 guests