How to FreezePane Excel in Powershell - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

Forums Search Members

How to FreezePane Excel in Powershell

Last Post 27 Jun 2008 01:53 PM by edm365f31. 2 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

edm365f31

New Member
Posts:39
Avatar

26 Jun 2008 05:50 PM
In Vbscript : objExcel.Cells(3,2).Select objExcel.ActiveWindow.FreezePanes = True How do you do this in powershell?

halr9000

PowerShell MVP, Site Admin

Basic Member
Posts:335
Avatar

27 Jun 2008 04:51 AM
It's basically the same, with some minor syntax differences. $a = New-Object -comobject Excel.Application $a.Visible = $TRUE $b = $a.Workbooks.Add() $c = $b.Worksheets.Item(1) $c.Cells.Item(3,2).Select() $a.ActiveWindow.FreezePanes = $TRUE

Community Director, PowerShellCommunity.org Co-host, PowerScripting Podcast Author, TechProsaic

edm365f31

New Member
Posts:39
Avatar

27 Jun 2008 01:53 PM
This did thanks.. Edm Southampton, PA Powershell Newbie

You are not authorized to post a reply.

Active Forums 4.1