Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Signature
vb.net
vb.net
Public Property VerticalPosition() As Integer
Remarks

In Excel 2003 and 2007 use different scales for determining position.  The VerticallPosition will not be the same when using ExcelApplication for the two file types2007 and 2010 this property is measured in twips.
Values may be different than in ExcelApplication for earlier versions of Excel.

Example
Code Block
csharp
csharp
titleC#

          //--- Get the vertical position of the workbook window's upper left corner
          int winVert = wb.VerticalPosition;

          //--- Set the vertical position of the workbook window's upper left corner
          wb.VerticalPosition = 100;
        
Code Block
vb.net
vb.net
titlevb.net

          '--- Get the vertical position of the workbook window's upper left corner
          Dim winVert As Integer = wb.VerticalPosition

          '--- Set the vertical position of the workbook window's upper left corner
          wb.VerticalPosition = 100