topic-41196

Board index FiveWin for Harbour/xHarbour freeze rows in excel RESOLVED

artu01

Posts: 400

Joined: Fri May 11, 2007 08:20 PM

freeze rows in excel RESOLVED
Posted: Wed Dec 15, 2021 04:38 AM

Guys:
How can i do that?

Thanks

fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql

Jimmy

Posts: 1772

Joined: Thu Sep 05, 2019 05:32 AM

Re: freeze rows in excel
Posted: Wed Dec 15, 2021 05:21 AM

I have to look into my crystal ball ...
but I don't see a solution with so little information.

greeting,

Jimmy

artu01

Posts: 400

Joined: Fri May 11, 2007 08:20 PM

Re: freeze rows in excel
Posted: Wed Dec 15, 2021 05:56 AM

Jimmy wrote:I have to look into my crystal ball ...
but I don't see a solution with so little information.

I want to freeze rows in Excel
For example, the first two lines of My Excel sheet are frozen

fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql

hmpaquito

Posts: 1515

Joined: Thu Oct 30, 2008 02:37 PM

Re: freeze rows in excel
Posted: Wed Dec 15, 2021 09:30 AM

From recorded macro

Code (fw): Select all Collapse

Sub Macro1()
'
' Macro1 Macro
'

'
    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True
End Sub

artu01

Posts: 400

Joined: Fri May 11, 2007 08:20 PM

freeze rows in excel RESOLVED
Posted: Thu Dec 16, 2021 01:40 AM

I solved this way

Code (fw): Select all Collapse

oWin := oExcel:ActiveWindow
oSheet:Cells( 2, 1 ):Select()
oWin:FreezePanes := .t.

fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql

FiveTech Support Forums

Continue the discussion