Excel automation problem

[Kalle]

During Excel automation in VB one can lock lines for
scrolling by the following code

ActiveWindow.FreezePanes = True

what would be the equivalent in c#?

Is it some way to convert or generate Excel Macron in C#
rather than in VB?

Greateful for answers!
Kalle

[Nicholas Paldino [.NET/C# MVP]]

Kalle,

You would use the same property assignment in C#. However, VB makes
late-binding very easy (which I assume is what you are doing). In C#, it
would be easier if you placed a reference to the "Microsoft Excel Object
Library" in your project, and then cast the ActiveWindow instance (which is
off the Application object you will create) to the appropriate worksheet
instance.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- nick(dot)paldino=at=exisconsulting<dot>com

"Kalle" <ka************@neuro.ki.se> wrote in message
news:1b****************************@phx.gbl...

During Excel automation in VB one can lock lines for
scrolling by the following code

ActiveWindow.FreezePanes = True

what would be the equivalent in c#?

Is it some way to convert or generate Excel Macron in C#
rather than in VB?

Greateful for answers!
Kalle

[Kalle]

Thank you for a quick answer!
I've got it working now.
Kalle

-----Original Message-----
Kalle,

You would use the same property assignment in C#. However, VB makeslate-binding very easy (which I assume is what you are doing). In C#, itwould be easier if you placed a reference to the "Microsoft Excel ObjectLibrary" in your project, and then cast the ActiveWindow instance (which isoff the Application object you will create) to the appropriate worksheetinstance.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- nick(dot) paldino=at=exisconsulting<dot>com
"Kalle" <ka************@neuro.ki.se> wrote in message
news:1b****************************@phx.gbl...

During Excel automation in VB one can lock lines for
scrolling by the following code

ActiveWindow.FreezePanes = True

what would be the equivalent in c#?

Is it some way to convert or generate Excel Macron in C# rather than in VB?

Greateful for answers!
Kalle

.