Freezepane in new excel application

[Keith74]

Hi All

I have a workbook that opens a new instance of excel and i need to
freeze a row in it. The problem is i've no idea how to set the new
excel application to be the activewindow so i can freeze the row. Any
thoughts?

cheers

Keith

 

[Jim Cone]

xlApp.Visible = True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Keith74"
wrote in message
Hi All
I have a workbook that opens a new instance of excel and i need to
freeze a row in it. The problem is i've no idea how to set the new
excel application to be the activewindow so i can freeze the row. Any
thoughts?
cheers
Keith

 

[Keith74]

Hi Jim

this is the code i've been using

xlExcel.Visible = True
xlExcel.UserControl = True
wbWorkBk.Sheets(1).Activate
wbWorkBk.Sheets(1).Range("B7").Select
wbWorkBk.Sheets(1).Range("B7").Activate

ActiveWindow.FreezePanes = True
(just freezes the panes in the callng workbook)

AppActivate isn't much help either

 

[Jim Cone]

Try...
xlExcel.Windows(1).FreezePanes = True
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Keith74"
<[email protected]>
wrote in message
Hi Jim
this is the code i've been using

xlExcel.Visible = True
xlExcel.UserControl = True
wbWorkBk.Sheets(1).Activate
wbWorkBk.Sheets(1).Range("B7").Select
wbWorkBk.Sheets(1).Range("B7").Activate

ActiveWindow.FreezePanes = True
(just freezes the panes in the callng workbook)
AppActivate isn't much help either

 

[Keith74]

Cheers Jim

Just came up with

xlexcel.windows(wbWorkBk.name).FreezePanes = true

before reading yours.

thanks for the help

cheers

keith