Re^2: Help inserting page break in Microsoft Excel using OLE

Replies are listed 'Best First'.
Re^3: Help inserting page break in Microsoft Excel using OLE by Joost (Canon) on Mar 01, 2005 at 19:29 UTC
You could possibly replace $ActiveWindow->SelectedSheets with $sheet . Not that I know anything about OLE. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re^4: Help inserting page break in Microsoft Excel using OLE by jobs_ron (Acolyte) on Mar 01, 2005 at 19:34 UTC
Thank you. I did try this, although I changed the code from this: `$sheet -> HPageBreaks -> Add({Before => $ActiveCell});` [download] to this: `$sheet -> HPageBreaks -> Add({Before => $sheet -> ActiveCell});` [download] Still, nothing happens.	[reply] [d/l] [select]
Re^5: Help inserting page break in Microsoft Excel using OLE by jobs_ron (Acolyte) on Mar 01, 2005 at 23:55 UTC
I finally figured it out! You can not replace "ActiveWindow -> SelectedSheets" with "$sheet." Instead, you use this: $excel -> ActiveWindow -> SelectedSheets -> HPageBreaks -> Add({Before => $sheet -> Range("6:6")}); This inserts a page break before row six. Thank you anyway to those who looked at my problem.	[reply]