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.

 

[Kalle]

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