Excel Automation RRS feed

  • Question

  • Right now i'm working on Excel automation using VB 6.0. My requirement is to set the page break at different positons on the excel sheet. This i'm able do with the following code


    objWorkbook.Worksheets("Sheet1").Rows(x).PageBreak = -4135
    objWorkbook.Worksheets("Sheet1").Columns(y).PageBreak = -4135 


    But whenever i insert the manual page break, automatic page break is turned on which overrides my manual page break settings. Is there a way to disable or move automatic page break to Manual page break location? Please do let me know......


    Thanks in advance

    Saturday, October 6, 2007 11:24 AM