Search the Community
Showing results for tags 'dragoff'.
Found 1 result
-
How to adapt VPageBreak.DragOff Method (Excel)
UEZ posted a topic in AutoIt General Help and Support
I want to remove the vertical page breaks so that I have only "page 1" available. Here the link to MSDN how to do it in VBA which works properly: https://msdn.microsoft.com/EN-US/library/office/ff836174.aspx What I did and doesn't work: With $oExcel_Export2Excel.Worksheets(1) .VPageBreaks(1).DragOff.Direction = -4161 ;$xlToRight = -4161 .VPageBreaks(1).DragOff.RegionIndex = 1 EndWith Local $aParam[2] = [-4161, 1] $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff($aParam) $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff(-4161, 1) $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff("Direction").Value = -4161 $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff("RegionIndex").Value = 1 $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff.Direction = -4161 $oExcel_Export2Excel.Worksheets(1).VPageBreaks(1).DragOff.RegionIndex = 1 Any further idea? I'm using Office 2013 only!