Help with Excel FreezePanes from code

[lanem]

I can't get this to work. Please help. Here's my code:

Dim xl As New Spreadsheet

xl.Selection.Cells(2, 2).Activate()
xl.ActiveWindow.FreezePanes = True

There's no errors . . . it just doesn't set up the FreezePanes stuff.

 

[Tom Ogilvy]

Dim xl As Worksheet

Set xl = Activesheet
xl.Selection.Cells(2, 2).Activate()
xl.ActiveWindow.FreezePanes = True

 

[lanem]

That did not help.

BTW, I'm doing this from ASP.NET 2.0 using VB.NET.

Thanks anyway.