FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Error in txbrowse:ToExcel
Posts: 166
Joined: Wed Aug 29, 2012 08:25 AM
Error in txbrowse:ToExcel
Posted: Thu Jul 10, 2014 09:43 AM

Hello,

Without changing the code the last month's , one off mine custumers reports a error the last days in xbrowse:toexcel :

oWin := oExcel:ActiveWindow
oWin:SplitRow := 1
oWin:FreezePanes := .t. <--- Gives error

Error description: Error Excel.Application:ACTIVEWINDOW/3 DISP_E_MEMBERNOTFOUND: _FREEZEPANES
Args:
[ 1] = L .T.

It seems that oWin has no data FreezePanels. Can it depend from the excel version ?

Frank

test
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Error in txbrowse:ToExcel
Posted: Fri Jul 11, 2014 01:52 AM

May we know the Excel version of your customer?
The code works well from version 2003 onwards.

Regards



G. N. Rao.

Hyderabad, India
Posts: 166
Joined: Wed Aug 29, 2012 08:25 AM
Re: Error in txbrowse:ToExcel
Posted: Mon Jul 28, 2014 10:45 AM
nageswaragunupudi wrote:May we know the Excel version of your customer?
The code works well from version 2003 onwards.


From customer :
newest version Office 2013

I will try to omit the line :

oWin:FreezePanes := .t. <--- Gives error

Or , can it be changed in another line ?

Frank
test
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Error in txbrowse:ToExcel
Posted: Mon Jul 28, 2014 01:42 PM

The code is correct and I can not suggest any alternative.
Also I am not able explain why the user should get this error.
Have you tested on your own PCs? Do you yourself face this problem?

ok. For the user you may try deleting this line or keep it in TRY/CATCH construct.

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion