Print Page - freeze header row in Excel.

Title: freeze header row in Excel.
Post by: RAK on February 27, 2015, 06:04:32 PM

I found "ActiveWindow.FreezePanes = True" but I cannot get it to work..

please help
thanks
Roy

Title: Re: freeze header row in Excel.
Post by: stanl on February 28, 2015, 03:27:23 AM

Quote from: RAK on February 27, 2015, 06:04:32 PM
I found "ActiveWindow.FreezePanes = True" but I cannot get it to work..

please help
thanks
Roy

Maybe

oXL.ActiveWindow.FreezePanes = @True

where oXL is the Excel Object. This is a fairly common issue with translating macros ino WB. Macro and VBA code allows you to shortcut the references, while WB needs the full reference.

Title: Re: freeze header row in Excel.
Post by: RAK on March 01, 2015, 05:06:33 AM

You got it! You have also helped me with additional conversion from VBA to WB. I now understand the need to include the "external" program call. I get it now.

thanks Stanl!

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: RAK on February 27, 2015, 06:04:32 PM