Page tree

Versions Compared

Key

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

...

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

In Excel 2003 and 2007 use different scales for determining position.  The HorizontalPosition 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 horizontal position of the workbook window's upper left corner
          int winHoriz = wb.HorizontalPosition;

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

          '--- Get the horizontal position of the workbook window's upper left corner
          Dim winHoriz As Integer = wb.HorizontalPosition

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