<div>
Rock on... letme try this... Thank you!
</div>


<div>
<div class="content wysiwyg-content">
Ok,<br />
<br />
We've determined that this works to ADD a comment:<br />
<br />
[void] $CurrentSheet.Cells.Item($<wbr />ServerRow+<wbr />1,$ServerC<wbr />ol).Addcom<wbr />ment(&quot;comm<wbr />ent&quot;)<br />
[void] $CurrentSheet.Cells.Item($<wbr />ServerRow+<wbr />1,$ServerC<wbr />ol).Commen<wbr />t.Text(&quot;Ne<wbr />w comment&quot;)<br />
<br />
BUT: &nbsp;How do you set the display size of the (area size) of the comment from Powershell?<br />
<br />
I need to size the comment so that it can be hovered over and actually read...<br />
<br />
Probably some like a 60 x 15 like rectangle...<br />
<br />
Thoughts?
</div>
</div>


Ok,

We've determined that this works to ADD a comment:

[void] $CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Addcomment("comment")
[void] $CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Comment.Text("New comment")

BUT:  How do you set the display size of the (area size) of the comment from Powershell?

I need to size the comment so that it can be hovered over and actually read...

Probably some like a 60 x 15 like rectangle...

Thoughts?

Powershell... next Excel formatting Question

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.