how to freeze and unfreeze panes in window by using Excel from LabVIEW

[hema]

Hello

I am creating an Excel Report file programmatically using LabVIEW. I make the row headers for the sheet and store data using the program.

The requirement that i need is that when the user opens the Excel sheet, the row heading should remain fixed at top, as the sheet is scrolled down by the user.

This is possible in Excel, by clicking on Window in the menu bar and then select Freeze panes/Unfreeze panes. The same operation i need, to be done from LabVIEW. Please let me know how this can be done.

I use LabVIEW 2009

Thank you.

[Cory_K · Accepted solution]

Please see this discussion. TCPlomp has an example of how to achieve this.