freeze pane in excel using vbs

[Al]

I have a script that scans ip ranges for vulnerabilities. In the
first row it list what each column is. Is there a way in my vbscript
to define the first row as a freeze pane? thanks

[Richard Mueller [MVP]]

Al wrote:

If objExcel is the Excel application, and objSheet is the spreadsheet, the
following will freeze panes to the left of column "B" and above row "5":

objSheet.Select
objSheet.Range("B5").Select
objExcel.ActiveWindow.FreezePanes = True

I demonstrate this in a sample program that writes info to an Excel
spreadsheet and does some formatting at this link:

http://www.rlmueller.net/Write%20to%20Excel.htm

From your description, you want to select "A2" before freezing. That would
freeze just the first row.

--
Richard
Microsoft MVP Scripting and ADSI
HilltopLab web site - http://www.rlmueller.net
--