{.ActiveWindow.FreezePanes = True} not working for me

[David A.]

I am converting some code that used the excel obect to use owc11.spreadsheet.
I have this snippet that behaves as expected with Excel.Application but does
not with owc11:

ExcelWorkBook.Sheets(1).Range('C8').Select
ExcelWorkBook.ActiveWindow.FreezePanes = True

I am calling this from COM and then exporting it to a file.

 

[Alvin Bruney [MVP - ASP.NET]]

That won't work. By the time you export the worksheet, the freezepane
functionality is lost. You may have better luck trying to freeze the pane
from the file itself with a macro load function.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc