Use OLE modify EXCEL.-CodePudding

To ask... using ole control changes EXCEL freeze panes command is how to write?
Such as freezing the first line...

CodePudding user response:

refer to the original poster yhwdai response:

to ask... using ole control changes EXCEL freeze panes command is how to write?
Such as freezing the first line...

Vba as follows, translated into pb code try

Range (" a1 "). Select
With ActiveWindow
. SplitColumn=0
. SplitRow=1
End With
ActiveWindow. FreezePanes=True

CodePudding user response:

Can you help me to PB code? Thank you ~ is not here...

CodePudding user response:

You can try:

Ole_1. Object. Application. ActiveWindow. FreezePanes=True

CodePudding user response:

Can learn this:
Excelserver. Activesheet. Rows (" 1 "). Select
Excelserver. ActiveWindow. SplitColumn=0
Excelserver. ActiveWindow. SplitRow=1
Excelserver. ActiveWindow. FreezePanes=True

CodePudding user response:

This code is good