Error in txbrowse:ToExcel

[Franklin Demont]

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

[nageswaragunupudi]

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

[Franklin Demont]

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

[nageswaragunupudi]

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.