Freezepane in new excel application

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith74 - 31 Jan 2008 11:29 GMT

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

Reply to this Message

Jim Cone - 31 Jan 2008 12:33 GMT

xlApp.Visible = True

Signature

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

Reply to this Message

Keith74 - 31 Jan 2008 13:22 GMT

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

Reply to this Message

Jim Cone - 31 Jan 2008 13:41 GMT

Try...
xlExcel.Windows(1).FreezePanes = True

Signature

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

"Keith74"
<keith.willis@sbjbc.co.uk>
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

Reply to this Message

Keith74 - 31 Jan 2008 13:52 GMT

Cheers Jim

Just came up with

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

before reading yours.

thanks for the help

cheers

keith

Reply to this Message