Help with Excel FreezePanes from code

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.

Dim xl As Worksheet

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

--
Regards,
Tom Ogilvy


"lanem" wrote:

> 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.

That did not help.

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

Thanks anyway.

"Tom Ogilvy" wrote:

> Dim xl As Worksheet
>
> Set xl = Activesheet
> xl.Selection.Cells(2, 2).Activate()
> xl.ActiveWindow.FreezePanes = True
>
> --
> Regards,
> Tom Ogilvy
>
>
> "lanem" wrote:
>
> > 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.